6.6.2 Where dynamic parameters can be specified
The following table lists the places where a dynamic parameter can be specified.
No. |
SQL statement |
Where dynamic parameters can be specified |
---|---|---|
1 |
SELECT |
Selection expression#1 |
2 |
Places where literals can be specified in the search conditions#2 |
|
3 |
ORDER BY clause#1 |
|
4 |
LIMIT clause |
|
5 |
INSERT |
Insertion value or row insertion value |
6 |
UPDATE |
Update value or row update value |
7 |
Places where literals can be specified in the search conditions#2 |
|
8 |
DELETE |
Places where literals can be specified in the search conditions#2 |
9 |
PURGE CHUNK |
- #1
-
The dynamic parameter cannot be specified by itself.
- #2
-
It cannot be specified in the following places:
-
On both sides of a comparison predicate
-
On the left side of a BETWEEN predicate
-
In a view definition (CREATE VIEW)
-
In a WITH clause
-