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;