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.
![sqleditor create a comment area sqleditor create a comment area](https://community.tibco.com/sites/default/files/capture3.png)
With the exception of hints, comments within SQL statements do not affect the statement execution.
![sqleditor create a comment area sqleditor create a comment area](http://4.bp.blogspot.com/-n8IgyWbgBKo/U5oUTrsBeXI/AAAAAAAACiE/vR9jUI1GIJQ/s1600/Query+Editor.png)
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.