A delimiter is a simple or compound symbol that has a special meaning in PL/SQL.
For example, you use delimiters to represent arithmetic operations such as addition and subtraction.
A list of PL/SQL delimiters is shown in the following table.
| 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 delimiter (begin and end) |
| -- | Single-line comment indicator |
| . . | Range operator |
| <, >, <=, >= | Relational operators |
| <>, '=, ~=, ^= | Different version of NOT EQUAL |