查找所有SEQUENCE、TABLE

查找所有SEQUENCE、TABLE

 

select * from user_objects ubs;

  www.zzzyk.com  

select * from user_objects ubs where ubs.OBJECT_TYPE='SEQUENCE'; 

 

 --查找所有SEQUENCE

 

select * from user_objects ubs where ubs.OBJECT_TYPE='TABLE';

 

--查找所有TABLE