azurelunatic: Vivid pink Alaskan wild rose. (Default)
Azure Jane Lunatic (Azz) 🌺 ([personal profile] azurelunatic) wrote2003-04-21 10:07 am

Burns' class. PL/SQL.

"Oh, we're following the syllabus?" -- the blonde
guess who forgot paper?


DECLARE
BEGIN
.......executable statement(s)
EXCEPTION
.......error handling
END

comments, w00t.
"Slashes which way? backward or forward?" --Burns
"whichever way makes it turn green." --forgetful student

-- single line comment
/* multiple
line
comment */
/*still legal*/

SQL*PLUS does not turn comments green.

"Comments will adhere to American Standard English as taught at DeVry."


Conditional Control in PL/SQL

IF
ELSIF /*Burns makes us adhere to American standard English, but he never said Oracle had to.*/

/*"What, do we leave out the D?" --smartass who's not me

EIF "...I'm kidding, I'm kidding!" --Burns*/

END /*space*/ IF;

IF THEN
ELSIF ELSE
END IF

class = 'over'
THEN
go home!