Introduction to PL/SQL
PL/SQL (Procedural Language/Structured Query Language) is a powerful procedural extension to SQL developed by Oracle Corporation. It is used to write complex database applications, automate tasks, and enhance the capabilities…
Oracle Cheat Sheet
Oracle Database is a comprehensive and robust relational database management system (RDBMS) widely used for enterprise-level applications. This cheat sheet presents essential commands and queries to interact efficiently with Oracle…
How to use Oracle’s decode() function
The DECODE function in Oracle, available from version 9i and above, serves as a powerful and concise alternative to using IF-THEN-ELSE statements. It provides a way to conditionally transform or…
Python3 with Oracle Database
Installation These instructions are for Mac OS: First install homebrew. Never use sudo for brew. Install Python3. The installation comes with pip3. Install cx_Oracle, the library that allows python3 to…
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 the syntax For example, This is like saying the following…
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,…
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…
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…