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. The main difference is that the lines commented out using the REM command will be displayed during execution of the batch file (can be avoided by setting off) while the lines commented out using ::, won’t be printed.Comments can make your application easier for you to read and maintain. This note shows how to comment batch files in Windows.Ĭool Tip: Get the return code from the last command or application! Read more → Batch File CommentĪ batch file can be commented using either two colons :: or a REM command. It is a good practice to comment a source code in a batch file by leaving the remarks that explain functionality of some lines or blocks of code.Īlso any line or a block of code in a batch file can be disabled by turning it into a comment (comment out) and enabled back (uncomment). bat extension and includes one or more command prompt commands. A batch file (batch script) in Windows is a text file that typically has a.
0 kommentar(er)
