首页 > 代码库 > Oracle部分常用语句

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部分常用语句