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…
Quick Introduction to Apache Spark
Spark a distributed computing platform that is built on top of Hadoop MapReduce. It extends the MapReduce model and make…
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…