6.6.2 Locations where dynamic parameters can be specified
The following table shows the locations where dynamic parameters can be specified.
|
No. |
SQL statement |
Locations where dynamic parameters can be specified |
|---|---|---|
|
1 |
SELECT COPY |
Selection expression#1 |
|
2 |
Locations where literals can be specified in search conditions#2 |
|
|
3 |
GROUP BY clause#1 |
|
|
4 |
ORDER BY clause#1 |
|
|
5 |
LIMIT clause |
|
|
6 |
INSERT |
Insertion value, and row insertion value |
|
7 |
UPDATE |
Update value, and row update value |
|
8 |
Locations where literals can be specified in search conditions#2 |
|
|
9 |
DELETE |
Locations where literals can be specified in search conditions#2 |
|
10 |
PURGE CHUNK |
- #1
-
You cannot specify a dynamic parameter by itself .
- #2
-
Dynamic parameters cannot be specified in the following locations.
-
On both sides of the comparison predicate
-
To the left of the BETWEEN predicate
-
Viewed definition (CREATE VIEW)
-