11.07 How to use "% "symbol ............................. 67
11.08 How to use equal (=) operator in condition?
................................................................................... 67
11.09 How to use like operator ............................ 68
11.10 How to use upper ( ) function ..................... 69
11.11 How to use lower ( ) function ..................... 69
11.12 How to use Initial ( ) function .................... 69
11.14 How to use LPAD ( ) function .................... 72
11.15 How to use CONCAT function................... 72
11.16 How to use substr( ) function ..................... 72
11.17 How to use LTRIM( ) function ................... 73
11.18 How to use RTRIM( ) function................... 74
11.19 How to use TRIM( ) function ..................... 74
11.20 How to use LENGTH( ) function ............... 75
12 - HOW TO RETRIEVE NUMERIC DATA ............ 77
12.01 How to use numeric operator ( + ) addition 77
12.02 How to use numeric operator ( - ) subtraction
78
12.03 How to use numeric operator ( * )
multiplication ............................................................ 78
12.04 How to use numeric operator ( I ) division . 78
12.05 How to use ceil( ) function ......................... 79
12.06 How to use floor( ) function ....................... 79
12.07 How to use power( ) function ..................... 79
12.08 How to use remainder( ) function ............... 80
12.09 How to use round( ) function...................... 80
12.11 How to use max( ) function ........................ 82
12.12 How to use min( ) function ......................... 82
12.13 How to use avg( ) function ......................... 83
12.14 How to use count( ) function ...................... 83
13 - HOW TO RETRIEVE DATE DATA .................... 85