A syntax error can be detected by the PL/SQL compiler. A runtime error occurs
while the program is running and cannot be detected by the PL/SQL compiler.
A misspelled keyword is an example of a syntax error. For example, this script:
DBMS_OUTPUT.PUT_LINE ('This is a test');
contains a syntax error. Try to find it.
A SELECT INTO statement returning no rows is an example of a runtime error. This
error can be handled with the help of the exception-handling section of the