161 lines
20 KiB
Text
161 lines
20 KiB
Text
|
<span class="hljs-comment">-- clauses (part 2)</span>
|
||
|
|
|
||
|
|
<span class="hljs-keyword">ADMIN</span> <span class="hljs-keyword">OPTION</span>,
|
||
|
|
<span class="hljs-keyword">ALL</span>,
|
||
|
|
<span class="hljs-keyword">ANALYZE</span>, <span class="hljs-keyword">ANALYZE</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">AS ASSIGNMENT</span>, <span class="hljs-keyword">AS IMPLICIT</span>,
|
||
|
|
<span class="hljs-keyword">AS PERMISSIVE</span>, <span class="hljs-keyword">AS RESTRICTIVE</span>,
|
||
|
|
<span class="hljs-keyword">AS ENUM</span>, <span class="hljs-keyword">AS RANGE</span>,
|
||
|
|
<span class="hljs-keyword">AS</span> ( .. ), <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">ASC</span>, <span class="hljs-keyword">DESC</span>,
|
||
|
|
<span class="hljs-keyword">ATTACH PARTITION</span>,
|
||
|
|
<span class="hljs-keyword">AUTHORIZATION</span>,
|
||
|
|
<span class="hljs-keyword">BEFORE</span>, <span class="hljs-keyword">AFTER</span>, <span class="hljs-keyword">INSTEAD</span> <span class="hljs-keyword">OF</span>,
|
||
|
|
<span class="hljs-keyword">CACHE</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">NO</span> <span class="hljs-keyword">CYCLE</span>,
|
||
|
|
<span class="hljs-keyword">CALLED</span> <span class="hljs-keyword">ON</span> <span class="hljs-keyword">NULL</span> <span class="hljs-keyword">INPUT</span>, <span class="hljs-keyword">RETURNS</span> <span class="hljs-keyword">NULL</span> <span class="hljs-keyword">ON</span> <span class="hljs-keyword">NULL</span> <span class="hljs-keyword">INPUT</span>,
|
||
|
|
<span class="hljs-keyword">COLLATE</span>,
|
||
|
|
<span class="hljs-keyword">CONCURRENTLY</span>,
|
||
|
|
<span class="hljs-keyword">CONNECTION</span> <span class="hljs-string">'..'</span>,
|
||
|
|
<span class="hljs-keyword">CONSTRAINT</span>,
|
||
|
|
<span class="hljs-keyword">COST</span> <span class="hljs-number">100</span>,
|
||
|
|
<span class="hljs-keyword">CLUSTER</span> <span class="hljs-keyword">ON</span>,
|
||
|
|
<span class="hljs-keyword">CURSOR</span>,
|
||
|
|
<span class="hljs-keyword">DEPENDS</span> <span class="hljs-keyword">ON</span> <span class="hljs-keyword">EXTENSION</span>,
|
||
|
|
<span class="hljs-keyword">DISABLE</span>, <span class="hljs-keyword">ENABLE</span>
|
||
|
|
<span class="hljs-keyword">REPLICA</span>, <span class="hljs-keyword">ALWAYS</span>,
|
||
|
|
<span class="hljs-keyword">TRIGGER</span>, <span class="hljs-keyword">TRIGGER</span> <span class="hljs-keyword">USER</span>, <span class="hljs-keyword">REPLICA</span> <span class="hljs-keyword">TRIGGER</span>, <span class="hljs-keyword">ALWAYS</span> <span class="hljs-keyword">TRIGGER</span>, <span class="hljs-keyword">TRIGGER</span> <span class="hljs-keyword">ALL</span>,
|
||
|
|
<span class="hljs-keyword">RULE</span>, <span class="hljs-keyword">REPLICA</span> <span class="hljs-keyword">RULE</span>, <span class="hljs-keyword">ALWAYS</span> <span class="hljs-keyword">RULE</span>,
|
||
|
|
<span class="hljs-keyword">ROW</span> <span class="hljs-keyword">LEVEL</span> <span class="hljs-keyword">SECURITY</span>, <span class="hljs-keyword">FORCE ROW LEVEL SECURITY</span>, <span class="hljs-keyword">NO</span> <span class="hljs-keyword">FORCE ROW LEVEL SECURITY</span>,
|
||
|
|
<span class="hljs-keyword">DISCARD PLANS</span>,
|
||
|
|
<span class="hljs-keyword">DISTINCT</span>, <span class="hljs-keyword">DISTINCT</span> <span class="hljs-keyword">ON</span> ( .. ), <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">DO</span> <span class="hljs-keyword">ALSO</span> .., <span class="hljs-keyword">DO</span> <span class="hljs-keyword">INSTEAD</span> .., <span class="hljs-keyword">DO</span> <span class="hljs-keyword">ALSO</span> <span class="hljs-keyword">NOTHING</span>, <span class="hljs-keyword">DO</span> <span class="hljs-keyword">INSTEAD</span> <span class="hljs-keyword">NOTHING</span>,
|
||
|
|
<span class="hljs-keyword">DO</span> <span class="hljs-keyword">NOTHING</span>, <span class="hljs-keyword">DO</span> <span class="hljs-keyword">UPDATE</span>,
|
||
|
|
<span class="hljs-keyword">EXCEPT</span>,
|
||
|
|
<span class="hljs-keyword">EXECUTE</span> <span class="hljs-keyword">PROCEDURE</span>,
|
||
|
|
<span class="hljs-keyword">EXPLAIN</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">EXTERNAL</span>,
|
||
|
|
<span class="hljs-keyword">FAMILY</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">ROLE</span> .. <span class="hljs-keyword">IN</span> <span class="hljs-keyword">SCHEMA</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">USER</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">SEARCH</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">ORDER</span> <span class="hljs-keyword">BY</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">TABLE</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">ALL</span> <span class="hljs-keyword">TABLES</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">VALUES</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">VALUES</span> <span class="hljs-keyword">FROM</span> .. <span class="hljs-keyword">TO</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">VALUES</span> <span class="hljs-keyword">IN</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">ROW</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">EACH</span> <span class="hljs-keyword">ROW</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">STATEMENT</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">EACH</span> <span class="hljs-keyword">STATEMENT</span>,
|
||
|
|
<span class="hljs-keyword">FOR</span> <span class="hljs-keyword">UPDATE</span>, <span class="hljs-keyword">FOR NO KEY</span> <span class="hljs-keyword">UPDATE</span>, <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">SHARE</span>, <span class="hljs-keyword">FOR KEY</span> <span class="hljs-keyword">SHARE</span>,
|
||
|
|
<span class="hljs-keyword">FROM</span>,
|
||
|
|
<span class="hljs-keyword">FROM</span> <span class="hljs-string">'..'</span>, <span class="hljs-keyword">FROM PROGRAM</span>, <span class="hljs-keyword">FROM STDIN</span>,
|
||
|
|
<span class="hljs-keyword">FROM</span> <span class="hljs-keyword">SQL</span> <span class="hljs-keyword">WITH</span> <span class="hljs-keyword">FUNCTION</span>, <span class="hljs-keyword">TO</span> <span class="hljs-keyword">SQL</span> <span class="hljs-keyword">WITH</span> <span class="hljs-keyword">FUNCTION</span>,
|
||
|
|
<span class="hljs-keyword">FROM</span> ( .. ), <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">FUNCTION</span>, <span class="hljs-keyword">FUNCTIONS</span>,
|
||
|
|
<span class="hljs-keyword">GLOBAL</span>, <span class="hljs-comment">-- create global table</span>
|
||
|
|
<span class="hljs-keyword">GROUP</span> <span class="hljs-keyword">BY</span>,
|
||
|
|
<span class="hljs-keyword">HAVING</span>,
|
||
|
|
<span class="hljs-keyword">SELECT</span>,
|
||
|
|
<span class="hljs-keyword">INSERT</span>, <span class="hljs-keyword">UPDATE</span>, <span class="hljs-keyword">DELETE</span>, <span class="hljs-keyword">TRUNCATE</span>, <span class="hljs-keyword">REFERENCES</span>, <span class="hljs-keyword">TRIGGER</span>, <span class="hljs-keyword">USAGE</span>, <span class="hljs-keyword">EXECUTE</span>, <span class="hljs-keyword">ALL</span> <span class="hljs-keyword">PRIVILEGES</span>,
|
||
|
|
<span class="hljs-keyword">CONNECT</span>, <span class="hljs-keyword">TEMPORARY</span>, <span class="hljs-keyword">TEMP</span>,
|
||
|
|
<span class="hljs-keyword">HANDLER</span>, <span class="hljs-keyword">NO</span> <span class="hljs-keyword">HANDLER</span>
|
||
|
|
<span class="hljs-keyword">IF</span> <span class="hljs-keyword">EXISTS</span>, <span class="hljs-keyword">IF</span> <span class="hljs-keyword">NOT</span> <span class="hljs-keyword">EXISTS</span>,
|
||
|
|
<span class="hljs-keyword">IMMUTABLE</span>,
|
||
|
|
<span class="hljs-keyword">IN</span>
|
||
|
|
<span class="hljs-keyword">ACCESS</span> <span class="hljs-keyword">SHARE MODE</span>, <span class="hljs-keyword">ROW</span> <span class="hljs-keyword">SHARE MODE</span>, <span class="hljs-keyword">ROW</span> <span class="hljs-keyword">EXCLUSIVE MODE</span>, <span class="hljs-keyword">SHARE</span> <span class="hljs-keyword">UPDATE</span> <span class="hljs-keyword">EXCLUSIVE MODE</span>,
|
||
|
|
<span class="hljs-keyword">SHARE MODE</span>, <span class="hljs-keyword">SHARE</span> <span class="hljs-keyword">ROW</span> <span class="hljs-keyword">EXCLUSIVE MODE</span>, <span class="hljs-keyword">EXCLUSIVE MODE</span>, <span class="hljs-keyword">ACCESS</span> <span class="hljs-keyword">EXCLUSIVE MODE</span>,
|
||
|
|
<span class="hljs-keyword">INCREMENT</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">INCREMENT</span> <span class="hljs-keyword">BY</span> <span class="hljs-number">100</span>,
|
||
|
|
<span class="hljs-keyword">INHERIT</span>, <span class="hljs-keyword">NO</span> <span class="hljs-keyword">INHERIT</span>,
|
||
|
|
<span class="hljs-keyword">INHERITS</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">INLINE</span>,
|
||
|
|
<span class="hljs-keyword">INTO</span>,
|
||
|
|
<span class="hljs-keyword">JOIN</span>, <span class="hljs-keyword">INNER</span> <span class="hljs-keyword">JOIN</span>, <span class="hljs-keyword">LEFT OUTER JOIN</span>, <span class="hljs-keyword">RIGHT JOIN</span>, <span class="hljs-keyword">FULL</span> <span class="hljs-keyword">JOIN</span>, <span class="hljs-keyword">CROSS</span> <span class="hljs-keyword">JOIN</span>,
|
||
|
|
<span class="hljs-keyword">LANGUAGE</span>,
|
||
|
|
<span class="hljs-keyword">LATERAL</span>,
|
||
|
|
<span class="hljs-keyword">LEAKPROOF</span>, <span class="hljs-keyword">NOT</span> <span class="hljs-keyword">LEAKPROOF</span>,
|
||
|
|
<span class="hljs-keyword">LIMIT</span>, <span class="hljs-keyword">LIMIT</span> <span class="hljs-keyword">TO</span>,
|
||
|
|
<span class="hljs-keyword">LOCAL</span>, <span class="hljs-comment">-- create local table, set</span>
|
||
|
|
<span class="hljs-keyword">LOCATION</span>,
|
||
|
|
<span class="hljs-keyword">MAXVALUE</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">NO MAXVALUE</span>,
|
||
|
|
<span class="hljs-keyword">MINVALUE</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">NO MINVALUE</span>,
|
||
|
|
<span class="hljs-keyword">NATURAL</span>,
|
||
|
|
<span class="hljs-keyword">FETCH NEXT</span>, <span class="hljs-keyword">FETCH PRIOR</span>, <span class="hljs-keyword">FETCH FIRST</span>, <span class="hljs-keyword">FETCH LAST</span>, <span class="hljs-keyword">FETCH ABSOLUTE</span> <span class="hljs-number">10</span>, <span class="hljs-keyword">FETCH RELATIVE</span> <span class="hljs-number">10</span>,
|
||
|
|
<span class="hljs-keyword">FETCH</span> <span class="hljs-keyword">ALL</span>, <span class="hljs-keyword">FETCH FORWARD</span>, <span class="hljs-keyword">FETCH FORWARD</span> <span class="hljs-number">10</span>, <span class="hljs-keyword">FETCH FORWARD</span> <span class="hljs-keyword">ALL</span>,
|
||
|
|
<span class="hljs-keyword">FETCH BACKWARD</span>, <span class="hljs-keyword">FETCH BACKWARD</span> <span class="hljs-number">10</span>, <span class="hljs-keyword">FETCH BACKWARD</span> <span class="hljs-keyword">ALL</span>,
|
||
|
|
<span class="hljs-keyword">NOWAIT</span>,
|
||
|
|
<span class="hljs-keyword">NULLS FIRST</span>, <span class="hljs-keyword">NULLS LAST</span>,
|
||
|
|
<span class="hljs-keyword">OFFSET</span> <span class="hljs-number">10</span> <span class="hljs-keyword">ROW</span>, <span class="hljs-keyword">OFFSET</span> <span class="hljs-number">10</span> <span class="hljs-keyword">ROWS</span>, <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">ON</span> <span class="hljs-keyword">TABLES</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">SEQUENCES</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">FUNCTIONS</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">ROUTINES</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">TYPES</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">SCHEMAS</span>,
|
||
|
|
<span class="hljs-keyword">ON</span> <span class="hljs-keyword">COMMIT</span> <span class="hljs-keyword">PRESERVE ROWS</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">COMMIT</span> <span class="hljs-keyword">DELETE</span> <span class="hljs-keyword">ROWS</span>, <span class="hljs-keyword">ON</span> <span class="hljs-keyword">COMMIT</span> <span class="hljs-keyword">DROP</span>,
|
||
|
|
<span class="hljs-keyword">ONLY</span>,
|
||
|
|
<span class="hljs-keyword">OPTIONS</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">OPERATOR</span>,
|
||
|
|
<span class="hljs-keyword">OR REPLACE</span>,
|
||
|
|
<span class="hljs-keyword">OVERRIDING</span> <span class="hljs-keyword">SYSTEM</span> <span class="hljs-keyword">VALUE</span>, <span class="hljs-keyword">OVERRIDING</span> <span class="hljs-keyword">USER</span> <span class="hljs-keyword">VALUE</span>,
|
||
|
|
<span class="hljs-keyword">OWNER</span> <span class="hljs-keyword">TO</span> .., <span class="hljs-keyword">OWNER</span> <span class="hljs-keyword">TO</span> <span class="hljs-built_in">CURRENT_USER</span>, <span class="hljs-keyword">OWNER</span> <span class="hljs-keyword">TO</span> <span class="hljs-built_in">SESSION_USER</span>,
|
||
|
|
<span class="hljs-keyword">OWNED</span> <span class="hljs-keyword">BY</span>,
|
||
|
|
<span class="hljs-keyword">PARALLEL UNSAFE</span>, <span class="hljs-keyword">PARALLEL RESTRICTED</span>, <span class="hljs-keyword">PARALLEL SAFE</span>,
|
||
|
|
<span class="hljs-keyword">PARTITION BY RANGE</span> (), <span class="hljs-keyword">PARTITION BY LIST</span> (), <span class="hljs-keyword">PARTITION BY HASH</span> (),
|
||
|
|
<span class="hljs-keyword">PARTITION</span> <span class="hljs-keyword">OF</span> ..,
|
||
|
|
<span class="hljs-keyword">PREPARE</span>,
|
||
|
|
<span class="hljs-keyword">PROCEDURAL</span>,
|
||
|
|
<span class="hljs-keyword">PROCEDURES</span>,
|
||
|
|
<span class="hljs-keyword">RECURSIVE</span>, <span class="hljs-comment">-- create view</span>
|
||
|
|
<span class="hljs-keyword">REFERENCING OLD</span> <span class="hljs-keyword">TABLE</span>, <span class="hljs-keyword">REFERENCING NEW</span> <span class="hljs-keyword">TABLE</span>,
|
||
|
|
<span class="hljs-keyword">REFRESH</span> <span class="hljs-keyword">VERSION</span>, <span class="hljs-keyword">REFRESH</span> <span class="hljs-keyword">PUBLICATION</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">REINDEX</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">REPEATABLE</span> ( .. ), <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">REPLICA</span> <span class="hljs-keyword">IDENTITY</span>
|
||
|
|
<span class="hljs-keyword">DEFAULT</span>, <span class="hljs-keyword">USING</span> <span class="hljs-keyword">INDEX</span>, <span class="hljs-keyword">FULL</span>, <span class="hljs-keyword">NOTHING</span>,
|
||
|
|
<span class="hljs-keyword">RENAME</span>
|
||
|
|
<span class="hljs-keyword">CONSTRAINT</span> .. <span class="hljs-keyword">TO</span>, <span class="hljs-keyword">TO</span>, <span class="hljs-keyword">COLUMN</span> .. <span class="hljs-keyword">TO</span>,
|
||
|
|
<span class="hljs-keyword">RESET</span>, <span class="hljs-keyword">RESET</span> <span class="hljs-keyword">ALL</span>, <span class="hljs-keyword">RESET</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">RESTART</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">RESTART</span> <span class="hljs-keyword">WITH</span> <span class="hljs-number">100</span>,
|
||
|
|
<span class="hljs-keyword">RESTART</span> <span class="hljs-keyword">IDENTITY</span>, <span class="hljs-keyword">CONTINUE</span> <span class="hljs-keyword">IDENTITY</span>, <span class="hljs-comment">-- truncate</span>
|
||
|
|
<span class="hljs-keyword">RETURNS</span>, <span class="hljs-keyword">RETURNS</span> <span class="hljs-keyword">TABLE</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">RETURNING</span>,
|
||
|
|
<span class="hljs-keyword">ROLLUP</span> ( .. ), <span class="hljs-keyword">CUBE</span> ( .. ), <span class="hljs-keyword">GROUPING SETS</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">ROUTINES</span>,
|
||
|
|
<span class="hljs-keyword">ROW</span>, <span class="hljs-keyword">ROW</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">GRANT</span> <span class="hljs-keyword">OPTION</span>,
|
||
|
|
<span class="hljs-keyword">ROWS</span> <span class="hljs-number">100</span>,
|
||
|
|
<span class="hljs-keyword">SCROLL CURSOR</span>, <span class="hljs-keyword">NO SCROLL CURSOR</span>, <span class="hljs-keyword">BINARY CURSOR</span>, <span class="hljs-keyword">INSENSITIVE CURSOR</span>, <span class="hljs-comment">-- declare</span>
|
||
|
|
<span class="hljs-keyword">SEQUENCES</span>,
|
||
|
|
<span class="hljs-keyword">SECURITY</span> <span class="hljs-keyword">INVOKER</span>, <span class="hljs-keyword">SECURITY</span> <span class="hljs-keyword">DEFINER</span>,
|
||
|
|
<span class="hljs-keyword">SERVER</span>,
|
||
|
|
<span class="hljs-keyword">SESSION</span>, <span class="hljs-comment">-- set</span>
|
||
|
|
<span class="hljs-keyword">SKIP LOCKED</span>, <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">SNAPSHOT</span>, <span class="hljs-comment">-- set transaction</span>
|
||
|
|
<span class="hljs-keyword">STABLE</span>,
|
||
|
|
<span class="hljs-keyword">START</span> <span class="hljs-number">100</span>, <span class="hljs-keyword">START</span> <span class="hljs-keyword">WITH</span> <span class="hljs-number">100</span>,
|
||
|
|
<span class="hljs-keyword">STORAGE</span>,
|
||
|
|
<span class="hljs-keyword">STRICT</span>,
|
||
|
|
<span class="hljs-keyword">SYSTEM</span>, <span class="hljs-comment">-- reindex</span>
|
||
|
|
<span class="hljs-keyword">TABLES</span>,
|
||
|
|
<span class="hljs-keyword">TABLESAMPLE</span>,
|
||
|
|
<span class="hljs-keyword">TEMPORARY</span>, <span class="hljs-keyword">TEMP</span>, <span class="hljs-comment">-- create sequence/table/view, discard</span>
|
||
|
|
<span class="hljs-keyword">TO</span> <span class="hljs-keyword">GROUP</span>, <span class="hljs-built_in">PUBLIC</span> <span class="hljs-keyword">WITH</span> <span class="hljs-keyword">GRANT</span> <span class="hljs-keyword">OPTION</span>,
|
||
|
|
<span class="hljs-keyword">TO</span> <span class="hljs-string">'..'</span>, <span class="hljs-keyword">TO PROGRAM</span>, <span class="hljs-keyword">TO STDOUT</span>,
|
||
|
|
<span class="hljs-keyword">TRANSFORM</span> <span class="hljs-keyword">FOR</span> <span class="hljs-keyword">TYPE</span>,
|
||
|
|
<span class="hljs-keyword">TRUSTED</span>,
|
||
|
|
<span class="hljs-keyword">TYPE</span>,
|
||
|
|
<span class="hljs-keyword">UNIQUE</span>,
|
||
|
|
<span class="hljs-keyword">UNION</span>, <span class="hljs-keyword">INTERSECT</span>, <span class="hljs-keyword">EXCEPT</span>, <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">UNLOGGED</span>,
|
||
|
|
<span class="hljs-keyword">UPDATE</span> <span class="hljs-keyword">TO</span>,
|
||
|
|
<span class="hljs-keyword">USING</span> .., <span class="hljs-keyword">USING</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">VACUUM</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">VALIDATE</span> <span class="hljs-keyword">CONSTRAINT</span>,
|
||
|
|
<span class="hljs-keyword">VALIDATOR</span>, <span class="hljs-keyword">NO</span> <span class="hljs-keyword">VALIDATOR</span>,
|
||
|
|
<span class="hljs-keyword">VALUES</span>, <span class="hljs-keyword">VALUES</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">VERBOSE</span>,
|
||
|
|
<span class="hljs-keyword">VOLATILE</span>,
|
||
|
|
<span class="hljs-keyword">WHEN</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">WHERE</span>, <span class="hljs-keyword">WHERE</span> <span class="hljs-keyword">CURRENT</span> <span class="hljs-keyword">OF</span>,
|
||
|
|
<span class="hljs-keyword">WINDOW</span>,
|
||
|
|
<span class="hljs-keyword">WITH</span>, <span class="hljs-keyword">WITH</span> <span class="hljs-keyword">RECURSIVE</span>,
|
||
|
|
<span class="hljs-keyword">WITH</span> ALLOW_CONNECTIONS <span class="hljs-number">10</span> <span class="hljs-keyword">CONNECTION</span> <span class="hljs-keyword">LIMIT</span> <span class="hljs-number">1</span> IS_TEMPLATE <span class="hljs-keyword">true</span>,
|
||
|
|
<span class="hljs-keyword">WITH</span> <span class="hljs-keyword">CHECK</span> ( .. ),
|
||
|
|
<span class="hljs-keyword">WITH DATA</span>, <span class="hljs-keyword">WITH NO DATA</span>,
|
||
|
|
<span class="hljs-keyword">WITH</span> <span class="hljs-keyword">FUNCTION</span>, <span class="hljs-keyword">WITHOUT</span> <span class="hljs-keyword">FUNCTION</span>, <span class="hljs-keyword">WITH</span> <span class="hljs-keyword">INOUT</span>,
|
||
|
|
<span class="hljs-keyword">WITH</span> <span class="hljs-keyword">OPTIONS</span>,
|
||
|
|
<span class="hljs-keyword">WITH ORDINALITY</span>, <span class="hljs-comment">-- select</span>
|
||
|
|
<span class="hljs-keyword">WITH CASCADED CHECK OPTION</span>, <span class="hljs-keyword">WITH LOCAL CHECK OPTION</span>,
|
||
|
|
<span class="hljs-keyword">WITH HOLD</span>, <span class="hljs-keyword">WITHOUT HOLD</span>, <span class="hljs-comment">-- declare</span>
|
||
|
|
<span class="hljs-keyword">WITH</span>, <span class="hljs-keyword">WITH</span> ( .. ), ();
|