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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.