Oracle保留字查询

sunday2018

已于 2022-06-29 11:14:55 修改

阅读量590

点赞数

分类专栏： Oracle

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

本文链接：https://blog.csdn.net/sunday2018/article/details/125516074

版权

oracle sql

Oracle 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

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'