查找所有SEQUENCE、TABLE
select * from user_objects ubs;
www.2cto.com
select * from user_objects ubs where ubs.OBJECT_TYPE='SEQUENCE';
--查找所有SEQUENCE
select * from user_objects ubs where ubs.OBJECT_TYPE='TABLE';
--查找所有TABLE