ORACLE 常用片段

• Oracle pl/sql 常用查询

 

AutoReplace.txt：

　　sl=select * from dual where 1=1
　　slc=select count(*) from dual where 1=1
　　up=update set where 1=1
　　dl=delete from table where 1=1
      slidx=select t.*,i.index_type from all_ind_columns t,all_indexes i where t.index_name = i.index_name and t.table_name=upper('NAME')

 

查看DB_LINK：select * from all_db_links;

查看视图：select t.*,i.index_type from all_ind_columns t,all_indexes i where t.index_name = i.index_name and t.table_name=upper('NAME');

查看表字段： SELECT * FROM all_tab_columns WHERE TABLE_NAME='SFCP_LOANCARDCODE_RECORD';