Oracle數(shù)據(jù)庫(kù)常用的操作命令
摘要: Oracle數(shù)據(jù)庫(kù)常用的操作命令
常用的數(shù)據(jù)字典表:tab，user_tables,user_objects,user_catalog,user_constraints,user_cons_columns
1、視圖在所有存儲(chǔ)過程(數(shù)據(jù)字典表)中查詢是否有某一字符串的ＳＱＬ語(yǔ)句
select * from all_source where type='PROCEDURE' and lower(text) like '%student %'
select * from user_source where lower(text) like '%dbms_%'
select tname,cname,coltype,width from col where tname='STUDENT'
閱讀全文