PL/SQL Basic syntax

*2.pl/sql Basic Syntax 1) anonymous block a piece of PL/SQL that cannot be stored in the database. The basic structure is as follows: DECLARE//Variable declaration definition area (can be omitted) BEGIN//Business Process area EXCEPTION//exception handling area (can be omitted) END 2) Comment --in single-line comment  Tolerance/* Multiline Comment content */ 3) Console printout statement set serveroutput on;--Open console display dbms_output.put_line (content); 4) The simplest PL/SQL begin Dbms_output.put_line (' Hello pl/sql! '); End

PL/SQL Basic syntax