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

Oracle?????????????Oracle????????????????????????????????????1. ????```sqlselect * from tab/dba_tables/dba_objects/cat;

2. ?????

select table_name from user_tables;

3. ?????

select table_name from all_tables;

4. ??????

select table_name from dba_tables;

5. ????

select * from user_indexes;

???????

6. ??????

select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_nameand t.table_name = 'T_ACCT_CREDIT_APPLY';

2. Foreign Key??

select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P'and au.table_name = 'T_ACCT_CREDIT_APPLY';

3. Unique??

select column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'U'and au.table_name = 'T_ACCT_CREDIT_APPLY';

???????

4. ??????

select * from user_constraints c where c.constraint_type = 'R'and c.table_name = 'T_ACCT_CREDIT_APPLY';

2. ?????

select * from user_cons_columns cl where cl.constraint_name = 'CONSTRAINT_NAME';

3. ???????

select * from user_cons_columns cl where cl.constraint_name = 'CONSTRAINT_NAME';

?????????

4. ??????

case when instr(a.column_name,'_')=0 then a.column_nameelse substr(a.column_name,0,instr(a.column_name,'_')-1)end as column_name|| upper(substr(a.column_name,instr(a.column_name,'_')+1,1) )|| substr(a.column_name,instr(a.column_name,'_')+2)end as formatted_column_namefrom (select lower(column_name) as column_name from user_tab_columns where table_name = 'T_ACCT_CREDIT_APPLY') a;

????????????????????????????????????????????????????????????????