Add comments to an sql script.
REMARK Single line comment -- Single line comment /* Single line comment */ /* Multi Line comment */
A common mistake is to use /* but not followed by a space (or newline) this
will be interpreted as "/" and will execute the previous SQL command.
Although the actual comment will be ignored this behaviour can have significant unexpected results:
even if there's no previous command to execute then Oracle will error with "Nothing in SQL buffer to run".
UNIX style comments ( # at the beginning of a line) don't work - Oracle will interpret and execute the whole line. They do however work for import and export parameter files.
"It is a profitable thing, if one is wise, to seem foolish" ~ Aeschylus
SQL Plus commands
© Copyright SS64.com 1999-2013
Some rights reserved