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 specification and a package body. Package specification declares constants, variables,…
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 it easier to code and faster to execute. Spark provides…
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 to uppercase and lower to convert to lower case. Examples:…
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 engine processes PL/SQL statements. PL/SQL statements can reside on the…
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 into a single table. In a union, all tables must…
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: If string has a value, it will be displayed. If…
Listing Objects in Oracle
If you want to list tables in MySQL, you simply type the following command: Oracle does not provide such a short cut. You have to type the following command: The…
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 with a number format that displays a number with dollar…