#保留关键字
保留关键字为YashanDB所使用语法关键字的子集,相比普通的关键字,保留关键字不被允许作为名称标识符(例如表名称、列名称等),除非对其使用双引号。
通过查询V$RESERVED_WORDS视图可获得YashanDB所有的关键字信息。
# A-G
ACCESS ADD ALL ALTER ANALYZE AND ANY AS ASC AUDIT
BETWEEN
CASE CHAR CHECK COLUMN COMMENT COMPRESS CONNECT CONNECT_BY_ISCYCLE CONNECT_BY_ISLEAF CONNECT_BY_ROOT CONSTRAINT CONSTRAINTS CREATE CURRENT
DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP
ELSE 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