ORACLE查询系统保留关键字及表中是否有关键字

--查询数据库关键字

select * from v$reserved_words;

----查询指定表中是否有关键字

 select * from v$reserved_words where keyword in(select COLUMN_NAME 
  from all_tab_columns where table_name = upper('k_msg') and owner='DBO_MTOA_XJICPA');

 select * from v$reserved_words where keyword in(select COLUMN_NAME 
  from all_tab_columns where table_name = upper('k_msg'));

 

posted @ 2022-10-04 00:15  IT情深  阅读(13)  评论(0编辑  收藏  举报