Python3 with Oracle Database
Installation These instructions are for Mac OS: First install homebrew. Never use sudo for brew. Install Python3. The installation comes…
ORA-01858: a non-numeric character was found where a numeric was expected
Error Message What it means This error occurs if a wrong value is passed when converting a number or string…
Oracle decode() function
Decode function has the same functionality as an IF-THEN-ELSE statement. It is present in Oracle 9i and above. It has…
What is an Oracle Package
A package is an encapsulated collection of related PL/SQL types, objects, procedures, and other program objects. Packages have a package…
Commonly used code in Oracle
Changing case To change the first letter of the word to cap, use the inicap function. Use upper to covert…
What is PL/SQL
Procedural Language extension of SQL (PL/SQL) combines SQL with procedural programming features such as looping, conditionals, and reusable blocks. PL/SQL…
Oracle set operators: union, intersect, minus
The most commonly used set operators in Oracle are: union intersect minus Union Union combine results returned by two or queries…
Oracle NVL and NVL2 functions
NVL function NVL function can be used to substitute a value when null in encountered. It has the following syntax:…
Listing Objects in Oracle
If you want to list tables in MySQL, you simply type the following command: Oracle does not provide such a…
Adding a leading dollar sign ($) in front of a number in Oracle
There are two ways of adding a leading dollar sign to numbers in Oracle. You can either define the column…