Let Us Learn Oracle - Part 12 of N [ NVL function in Oracle ]
Source table: tblPlayers
Purpose: It substitute a value when a null value is encountered.
Syntax: NVL( ColumnName, ReplaceValue )
Where,
ColumnName => It is the column that is use for null value test.
ReplaceValue => Value that w......

Let Us Learn Oracle - Part 9 of N [ Decode function in Oracle ]
Source table: tblPlayers
Purpose: It is the value substitution function. It can also be treated as as shorter form of Case statement or Ternary Operator in C#/C/C++/Java etc.
Example:
SQL> Select PlayerLastName,DECODE(PlayerL......

Let Us Learn Oracle - Part 7 of N [ CHR function in Oracle ]
Source table: tblPlayers
Purpose: Return the ASCII character of the number specified
SQL> Select CHR(65) From Dual;
C
-
A
</pre>
It does not return the ASCII of any character
SQL> select chr('a') from dual;
select chr......

Let Us Learn Oracle - Part 6 of N [ RPad and LPad function in Oracle ]
Source table: tblPlayers
RPad
Syntax: RPad(InputString,length,[,set])
Purpose: Pads the right side of the column with the given character. It fills the display to the given length. If InputString is longer than length, s......