COMMENT IN BATCH SCRIPT EXAMPLE UPDATE
COMMENT IN BATCH SCRIPT EXAMPLE PLUS

COMMENT IN BATCH SCRIPT EXAMPLE PLUS

The space between the plus sign and the hint is optional. Hint is one of the hints discussed in this section. The plus sign must follow immediately after the comment delimiter (no space is permitted).

+ is a plus sign that causes Oracle to interpret the comment as a list of hints. Comments containing hints can appear only after these keywords.

COMMENT IN BATCH SCRIPT EXAMPLE UPDATE

+ hint ].ĭELETE, INSERT, SELECT, or UPDATE is a DELETE, INSERT, SELECT, or UPDATE keyword that begins a statement block. The following syntax shows hints contained in both styles of comments that Oracle supports within a statement block. The optimizer uses these hints as suggestions for choosing an execution plan for the statement.Ī statement block can have only one comment containing hints, and that comment must follow the SELECT, UPDATE, INSERT, or DELETE keyword. You can use comments in a SQL statement to pass instructions, or hints, to the Oracle Database optimizer. WHERE last_name = 'Pataballa') - of Pataballa. (SELECT salary + NVL(commission_pct,0) - the compensation Salary + NVL(commission_pct, 0),- total compensationĪND salary + NVL(commission_pct, 0) > - whose compensation

* total compensation is salar + commission_pct */ *The DEPARTMENTS table is used to get the department name.*/ĪND salary + NVL(commission_pct,0) > /* Subquery: */ * Select all employees whose compensation is These statements contain many comments: SELECT last_name, salary + NVL(commission_pct, 0), The text of a comment can contain any printable characters in your database character set. For more information, please refer to the documentation for the tool you use as an interface to the database.Ī SQL statement can contain multiple comments of both styles. For example, if you are using SQL*Plus, by default you cannot have a blank line inside a multiline comment. Some of the tools used to enter SQL have additional restrictions. The opening and terminating characters need not be separated from the text by a space or a line break.īegin the comment with - (two hyphens). End the comment with an asterisk and a slash (*/). You can include a comment in a statement in two ways:īegin the comment with a slash and an asterisk (/*). Please refer to 'Hints ' on using this particular form of comment.Ī comment can appear between any keywords, parameters, or punctuation marks in a statement. With the exception of hints, comments within SQL statements do not affect the statement execution. For example, you can include a comment in a statement that describes the purpose of the statement within your application. Comments can make your application easier for you to read and maintain.

Comment in batch script example