SQL Cheat sheet

SQL Cheat sheet: After following this SQL Cheat sheet we will be in a position to understand quickly and use SQL statement as per requirements.  Below are the SQL commands Cheat sheet mentioned which perform different kinds of operations. Various SQL types: DRL, DDL, DML, TCL, DCL  DESCRIPTION select syntax: DRL: DATA RETRIEVAL LANGUAGE COMMANDS …

SQL Cheat sheet Read More »

Oracle nvl2 function

Description: The Oracle NVL2 function extends the functionality of NVL function.  NVL2 function lets you substitutes values for both null and non-null values encountered. Syntax: NVL2( arg1, value_when_not_NULL, value_when_NULL ) arg1:   The string to test for a null value.value_when_not_NULL:   The value returned if string1 is not null.value_when_NULL:   The value returned if string1 …

Oracle nvl2 function Read More »