-- 检查 不符合 数据库 命名 规范 的字段名 select table_name,column_name,data_type from user_tab_columns where column_name in --(select keyword from v$reserved_words) (access,add,all,alter,and,any,as,asc,audit, between,by,char,check,cluster,
--检查不符合数据库命名规范的字段名
select table_name,column_name,data_type
from user_tab_columns
where column_name in --(select keyword from v$reserved_words)
('access','add','all','alter','and','any','as','asc','audit',
'between','by','char','check','cluster',
'column','comment','compress','connect','create','current',
'date','decimal','default','delete',
'desc','distinct','drop','else','exclusive','exists','file',
'float','for','from','grant','group',
'having','identified','immediate','in','increment','index',
'initial','insert','integer','intersect',
'into','is','level','like','lock','long','maxextents','minus',
'mlslabel','mode','modify','noaudit',
'nocompress','not','nowait','null','number','of','offline','on',
'online','option','or','order',
'pctfree','prior','privileges','public','raw','rename','resource',
'revoke','row','rowid','rownum',
'rows','select','session','set','share','size','smallint','start',
'successful','synonym','sysdate',
'table','then','to','trigger','uid','union','unique','update',
'user','validate','values','varchar',
'varchar2','view','whenever','where','with')
or column_name like '% %'
--检查数据库中相同名字不同类型的字段名
select a.column_name,a.data_type,b.data_type from
(select distinct column_name,data_type from
all_tab_columns where table_name like 't%') a,
(select distinct column_name,data_type from
all_tab_columns where table_name like 't%') b
where a.column_name=b.column_name and a.data_typeb.data_type
--检查数据库中相同名字相同类型不同长度的字段名
select a.column_name,a.data_type,b.data_type,
a.data_length,b.data_length from
(select distinct column_name,data_type,
data_length from all_tab_columns where table_name like 't%') a,
(select distinct column_name,data_type,
data_length from all_tab_columns where table_name like 't%') b
where a.column_name=b.column_name and a.data_type=b.data_type and a.data_lengthb.data_length