1.

What are PL/SQL Delimiters?

Answer»

A delimiter is a compound symbol with a special meaning to PL/SQL. For example, you USE delimiters to represent ARITHMETIC operations such division. For example, a delimiter symbol is also the assignment OPERATOR used in PL/SQL:

:=

An example would be:

DECLARE   device varchar2(15) := 'Laptop'; BEGIN   dbms_output.put_line(device); END; /

The following are the symbols of Delimiters:

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
&GT;
relational operator
@
remote access indicator
;
statement terminator
-
subtraction/negation operator
:=
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


Discussion

No Comment Found

Related InterviewSolutions