PL/SQL - Basic Syntax

PL/SQL - Basic Syntax - Comments - Program Units - First PLSQL program

Basic Syntax of a PL/SQL program is:


DECLARE
<declarations section>
BEGIN
<executable section>
EXCEPTION
<exception handling section>
END;

My 'First PL/SQL' Program:


DECLARE
v_message varchar2(20):= 'My first PLSQL program!';
BEGIN
dbms_output.put_line(v_message);
END;
/

Complete Tutorial

1 comment:

  1. 3D680FE5AA
    If you're interested in the latest trends and resources, be sure to check out dtfhub.com for comprehensive information. It offers valuable insights for enthusiasts and professionals alike. Exploring this site can help you stay updated and enhance your knowledge in the field. Remember, staying informed is key to success.

    ReplyDelete