COMMENTS In PL/SQL

COMMENTS

Comments improve readability and make your program more understandable. They are ignored by the PL/SQL compiler. There are two types of comments available.

1     Single line comments

2     Multiline comments

SINGLE LINE COMMENTS

A single-line comment can start any point on a line with two dashes and continues until the end of the line.

Ex:

                        BEGIN

                             Dbms_output.put_line(‘hello’);                   -- sample program

                        END;

MULTILINE COMMENTS

Multiline comments start with the /* delimiter and ends with */ delimiter.

Ex:

                        BEGIN

                             Dbms_output.put_line(‘hello’);                   /* sample program */

                        END;