Created
April 8, 2014 08:58
-
-
Save sqlparser/10102947 to your computer and use it in GitHub Desktop.
blank lines plsql if_else_elsif
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- 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