Delimiters
Delimiters are symbols or combinations of symbols with a special meaning to PL/SQL. PL/SQL delimiters are listed in Table 9-1.
Table 9-1. PL/SQL delimiters
|
Delimiter |
Usage |
|---|---|
|
; |
Terminator (for statements and declarations) |
|
+ - * / ** = |
Arithmetic operators |
|
<> != ^= ~= |
Inequality operators |
|
< > <= >= <> |
Comparison operators |
|
|| |
Concatenation operator |
|
:= |
Assignment operator |
|
( ) |
Expression or list delimiter |
|
, |
Comma. Item separator |
|
' |
Single quote. Literal delimiter |
|
" |
Double quote. Quoted literal delimiter |
|
<< >> |
Label delimiters |
|
: |
Host variable delimiter |
|
% |
Attribute delimiter |
|
. |
Period. Component indicator, as with fields in a record (record.field) or elements in a package (package.element) |
|
@ |
dblink (database link) indicator |
|
=> |
Association indicator for parameters in a call |
|
.. |
Two periods. Range operator used in a FOR loop |
|
— |
Single-line comment indicator |
|
/* */ |
Multiline comment indicator |
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
