Database Reference
In-Depth Information
Figure 18.27
Adding Comments
to the ARTIST
Table.
To remove a comment, you simply change the comment to a null-val-
ued string. Remove the comment from the CDTRACK table by typing and
executing the following command:
COMMENT ON TABLE CDTRACK IS '';
18.6.2
Scripting and SQL Code Comments
There are several methods for adding comments to a script, an SQL com-
mand, or a PL/SQL command. A script is a list of multiple SQL or PL/
SQL commands and is usually stored in a file:
Multiple-Line Comments
. Create multiple-line comments by
enclosing a commented area between /* and */ character strings. This
is useful for longer documentation, such as listing the creator of a
script, the date it was created, its purpose, and so on.
Inline Comments
. Precede inline comments with two consecutive
hyphen marks (--). This method marks everything found after the
double hyphens on the same line as a comment. You can comment an
entire line by placing the hyphens at the beginning of the line. You
