All the PL/SQL comments are known to be the explanatory statements that are included in the PL/SQL code that we write and also helps anyone reading the source code. All the program languages allow these types of comments. This language supports single-line and also multi-line comments. All the characters that are available inside any comments are then ignored by the PL/SQL compiler. Single line comments starts with the delimiter that is -- double hyphen and also multi-line comments that are then enclosed by the /* and */.
Syntax:
DECLARE -- variable declaration Message varchar2(20):= ‘Good Morning!’; BEGIN /* * PL/SQL executable statements(s) */ dbms_output.put_line(message); END; / When we execute the above code at the SQL Prompt, it gives following results –
Good Morning
PL/SQL procedure successfully completed.