These identifiers are known top be as the constants, exceptions, variables, procedures, cursors and also the reserved words. Then these identifiers also consist of a letter optionally that can also be followed by more letters, dollar signs, numerals, underscores and also number signs and that should not exceed 30 characters. And by default, identifiers are not case-sensitive. We can use either integer or INTEGER for representing a numeric value. We cannot use the reserved keyword as an identifier in PL/SQL.
PL/SQL Delimiters
Delimiters are the symbol with a special meaning. There is a list of delimiters in PL/SQL that are given below:
|
Delimiter |
Description |
|
+, -, *, / |
Addition, subtraction/negation, multiplication, division |
|
% |
Attribute indicator |
|
‘ |
Character string delimiter |
|
. |
Component selector |
|
(,) |
Expression or list delimiter |
|
: |
Host variable indicator |
|
, |
Item separator. |
|
“ |
Quoted Identifier delimiter |
|
= |
Relational operator |
|
@ |
Remote access indicator |
|
; |
Statement terminator |
|
:= |
Assignment operator |
|
=> |
Association operator |
|
|| |
Concatenation operator |
|
** |
Exponentiation operator |
|
<<, >> |
Label delimiter (begin and end) |
|
/*, */ |
Multi line comment (begin and end) |
|
- |
Single line comment indicator |
|
.. |
Range operator |
|
<, >, <=, >= |
Relational operators |
|
<>, ‘=, ~=, ^= |
Different versions of not equal. |
