Thursday, April 22, 2010

Delimiters in Oracle PL/SQL

A delimiter is a simple or compound symbol that has a special meaning to PL/SQL
Simple symbols consist of one character
























Symbol Meaning
+ addition operator
% attribute indicator
' character string delimiter
. component selector
/ division operator
( expression or list delimiter
) expression or list delimiter
: host variable indicator
, item separator
* multiplication operator
" quoted identifier delimiter
= relational operator
< relational operator
> relational operator
@
remote access indicator
;
statement terminator
-
subtraction/negation operator

Compound symbols consist of two characters. the following list shows
Compound symbols delimiters
















































:= assignment operator
=> association operator
|| concatenation operator
** exponentiation operator
'<<' label delimiter(Begin)
'>>' label delimiter(End)
/* multi-line comment delimiter (Begin)
*/ multi-line comment delimiter (end)
. . range operator
<> relational operator
!= relational operator
~= relational operator
^= relational operator
<= relational operator
>= relational operator
-- single-line comment indicator