本文共 552 字，大约阅读时间需要 1 分钟。

以下常用在异构库（保留字不同，当oracle遇到保留字时会在末尾加下划线_）迁移时候需注意的表名和字段变更对比：

查看表末尾是否带有下划线_

SELECT owner,table_name  FROM dba_tables where table_name  like'%/_' escape '/' and owner in('XXX1','XXX2') order by owner,table_name;

查看字段末尾是否带有下划线_

SELECT owner,table_name, column_name, data_type  FROM dba_tab_cols where column_name like'%/_' escape '/' and owner in('XXX1','XXX2') order by owner,table_name,column_name;

oracle的保留字：

select * from v$reserved_words order by keyword asc;

select count(*) from v$reserved_words;

转载地址：http://cnsof.baihongyu.com/