Skip to content

Instantly share code, notes, and snippets.

@sqlparser
Created April 8, 2014 08:58
Show Gist options
  • Save sqlparser/10102947 to your computer and use it in GitHub Desktop.
Save sqlparser/10102947 to your computer and use it in GitHub Desktop.
blank lines plsql if_else_elsif
--
-- If the student's grade point average meets the criteria for
-- mandatory academic counseling, add the student's name and social
-- security number to the list.
--
IF (nRealGPA < 1.5) THEN
<statements>
--
-- We also want to consider students who are failing two or more
-- classes, even if their GPA is above 1.5.
--
ELSIF Has_Two_Fails (nForSSN => nSSN) THEN
<statements>
ELSE
<statements>
END IF;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment