oracle如何查找所有SEQUENCE、TABLE。select * from user_objects ubs;
select * from user_objects ubs where ubs.OBJECT_TYPE=’SEQUENCE’; –查找所有SEQUENCE
select * from user_objects ubs where ubs.OBJECT_TYPE=’TABLE’;–查找所有TABLE
oracle如何查找所有SEQUENCE、TABLE。select * from user_objects ubs;
select * from user_objects ubs where ubs.OBJECT_TYPE=’SEQUENCE’; –查找所有SEQUENCE
select * from user_objects ubs where ubs.OBJECT_TYPE=’TABLE’;–查找所有TABLE