13.01 How to subtract dates to find number of days
85
13.02 How to use add_months( ) function .......... 86
13.03 How to use months_between( ) function .... 87
14- HOW TO CONVERT I TRANSFORM DATA ...... 88
CONVERSION:............................................................ 88
14.01 How to convert date type value to char type value 89
14.02 How to convert numeric data to char type as formatted ................................................................... 90
14.03 How to convert char type data as date type 90
14.04 How to convert formatted char type data as numeric type.............................................................. 91
14.05 How to use decode( ) function.................... 93
14.07 How to use group by clause........................ 94
14.09 How to use order by clause......................... 95
15 - HOW TO CREATE SEQUENCE ......................... 97
16 - HOW TO CREATE TABLE CONSTRAINT ..... 104
16.01 How to create Primary Key Constraint..... 105
16.02 HOW TO CREATE CHECK CONSTRAINT
107
16.04 HOW TO CREATE FOREIGN KEY CONSTRAINT ....................................................... 111
17 - HOW TO CREATE TRIGGERs ........................ 114
18- HOW TO LAND IN PLISQL ............................... 130
18.01 How to use if conditions ........................... 131
18.02 How to use nested if conditions................ 132
18.05 How to use for loop .................................. 136
18.06 How to use while loop .............................. 136
19-HOW TO CREATE FUNCTION .......................... 138
20-HOW TO CREATE PROCEDURE....................... 141