#保留关键字
保留关键字为YashanDB所使用语法关键字的子集,相比普通的关键字,保留关键字不被允许作为名称标识符(例如表名称、列名称等),除非对其使用双引号。
通过查询V$RESERVED_WORDS视图可获得YashanDB所有的关键字信息。
# A-G
ACCESS ADD ALL ALTER ANALYZE AND ANY AS ASC AUDIT
BETWEEN
CHAR CHECK COLUMN COMMENT COMPRESS CONNECT CONSTRAINT CONSTRAINTS CREATE CURRENT
DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP
ELSE EXCEPT EXISTS
FALSE FLOAT FOR FROM
GRANT GROUP
# H-N
HAVING HORDER
IDENTIFIED IF IMMEDIATE IN INCLUDE INCREMENT INDEX INSERT INTEGER INTERSECT INTO IS
LEVEL LIKE
MINUS MODIFY
NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER
# O-T
OF OFFLINE ON ONLINE OR ORDER
PRIOR PUBLIC
RAW RENAME REVOKE RLIKE ROW ROWS
SELECT SELECTIVITY SESSION SET SMALLINT START SUCCESSFUL SYNONYM SYSDATE
TABLE THEN TO TRIGGER TRUE
# U-Z
UNION UNIQUE UPDATE USER
VALIDATE VALUES VARCHAR VARCHAR2 VIEW
WHEN WHENEVER WHERE WITH WITHOUT
ZORDER