Oracle保留字查询

Oracle保留字查询：避开命名冲突的策略

原创已于 2022-06-29 11:14:55 修改 · 702 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #sql

于 2022-06-29 10:41:30 首次发布

Oracle 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了如何通过查询Oracle的保留字表，避免在创建表字段时使用这些关键字，以防止潜在的命名冲突。列举了多个保留字并展示了相应的SQL查询示例。

Oracle保留字查询

reserved='Y’的是Oracle的保留字符，不建议作为表字段名称

-- unit
select * from v$reserved_words where KEYWORD=upper('unit') AND reserved='Y'
--quantity
select * from v$reserved_words where KEYWORD=upper('quantity') AND reserved='Y'
-- value
select * from v$reserved_words where KEYWORD=upper('value') AND reserved='Y'
-- val
select * from v$reserved_words where KEYWORD=upper('val') AND reserved='Y'
-- type
select * from v$reserved_words where KEYWORD=upper('type') AND reserved='Y'
-- site
select * from v$reserved_words where KEYWORD=upper('site') AND reserved='Y'
-- creator
select * from v$reserved_words where KEYWORD=upper('creator') AND reserved='Y'
-- icon
select * from v$reserved_words where KEYWORD=upper('icon') AND reserved='Y'
-- visible
select * from v$reserved_words where KEYWORD=upper('visible') AND reserved='Y'
-- region
select * from v$reserved_words where KEYWORD=upper('region') AND reserved='Y'
-- module
select * from v$reserved_words where KEYWORD=upper('module') AND reserved='Y'
-- year
select * from v$reserved_words where KEYWORD=upper('year') AND reserved='Y'