I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL.
I noticed the T-SQL often uses Begin end after If statement, but Pl-SQL does not .
So look it up in the documentation of both RDBMSs. 😉
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!" Helpful Links: How to post code problems How to Post Performance Problems Create a Tally Function (fnTally)