"Be not afraid of going slowly, Be afraid of standing still.“Chinese Proverb
"Life is a succession of lessons, which must be lived to be understood."
-Ralph Waldo Emerson
The NZPLSQL language provides for the following types of procedural logic:
• Conditionals (if/else)
• Looping (while, for)
• Execution of SQL (including dynamic SQL)
• Returning a scalar result or a result set
• Input arguments
• Execution in the calling context (session and transaction)
• Extending functionality (adding NZPLSQL library routines)
A stored procedure is created (it is then automatically compiled), and then you run the stored procedure by either CALL or EXECUTE ...