Thursday, September 15, 2011

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.

Ø  Single line comments
Ø  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;

No comments:

Post a Comment

Oracle Escape Characters

Oracle allows the assignment of special escape characters to tell Oracle that the character is interpreted literally.  Certain characters ...