--查询数据库全部关键字
SELECT * FROM V$RESERVED_WORDS;
--查询表名是否和关键字冲突
CREATE TABLE MODE(C1 INT);
SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME IN (SELECT KEYWORD FROM V$RESERVED_WORDS);
--查询列名是否和关键字冲突
CREATE TABLE TEST(BUILD INT);
SELECT OWNER,TABLE_NAME,COLUMN_NAME FROM ALL_COL_COMMENTS WHERE OWNER<>'SYS' AND COLUMN_NAME IN (SELECT KEYWORD FROM V$RESERVED_WORDS);
文章
阅读量
获赞
