Oracle部分常用語句

標籤：

--query許可權即可查看系統有哪些失效的PKG。（我們系統的PKG一般是OPER使用者建立的）

select * from all_objects a where a.owner = ‘GNBSOPER‘ and a.status = ‘INVALID‘;

--查看系統資料表的約束

select * from all_contraints;

Type Code	Type Description	Acts On Level
C	Check on a table	Column
O	Read Only on a view	Object
P	Primary Key	Object
R	Referential AKA Foreign Key	Column
U	Unique Key	Column
V	Check Option on a view	Object

 

 

 

 

 

 

 

 

 

 

--oper許可權 查看所有job

select * from all_jobs;

 

Oracle部分常用語句