Suggestion: The lightbulb highlights suggestions and practical tips that could save time, make procedures easier, and so on.
Warning: The warning symbol highlights text that warns you of actions that could be particularly damaging or fatal to your system.
Additional Information: The OSDoc icon signifies the reader should refer to the Oracle operating system-specific documentation for additional information.
UPPERCASE | Uppercase text is used to call attention to names of SQL, PL/SQL, and Server Manager commands, SQL keywords, filenames, and initialization parameters. |
italics | Italicized text is used to call to attention to definitions of terms and parameters of SQL commands. Italics are also used for emphasizing certain words. |
This list shows parameters that appear in the syntax diagrams in this manual and examples of the values you might substitute for them in your statements:
Parameter | Description | Examples |
table | The substitution value must be the name of an object of the type specified by the parameter. | emp |
'text' | The substitution value must be a character literal in single quotes. | 'Employee records' |
condition | The substitution value must be a condition that evaluates to TRUE or FALSE. | ename > 'A' |
date d | The substitution value must be a date constant or an expression of DATE datatype. | TO_DATE( '01-Jan-1994', 'DD-MON-YYYY') |
expr | The substitution value can be an expression of any datatype. | sal + 1000 |
integer | The substitution value must be an integer. | 72 |
rowid | The substitution value must be an expression of datatype ROWID. | 00000462.0001.0001 |
subquery | The substitution value must be a SELECT statement contained in another SQL statement. | SELECT ename FROM emp |
statement_name block_name | The substitution value must be an identifier for a SQL statement or PL/SQL block. | s1 b1 |