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…
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
presenting numerical data with a leading dollar sign adds a touch of clarity and professionalism to reports and queries. Whether you’re a seasoned database administrator or a budding SQL enthusiast,…