SELECT
*
FROM
all_tables
WHERE
OWNER = '实例名称'
ORDER BY table_name;
方法一:
Select object_name From user_objects Where object_type='TRIGGER'; --所有触发器
Select object_name From user_objects Where object_type='PROCEDURE'; --所有存储过程
Select object_name From user_objects Where object_type='VIEW'; --所有视图
Select object_name From user_objects Where object_type='TABLE'; --所有表
方法二:
当然,还可以试试下面的语句
Select * From user_triggers; --所有触发器
Select * From user_procedures; --所有存储过程
Select * From user_views; --所有视图
Select * From user_tables; --所有表
--查看当前用户的所有序列
select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='用户名';
--查询当前用户的序列总数
select count(*) from dba_sequences where sequence_owner='用户名';
select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='PPNIE';
--生成删除该用户下的序列号的sql语句
select 'drop sequence ' ||SEQUENCE_NAME ||' ;' from dba_sequences where sequence_owner='PPNIE';
注意事项:
1. 必须以管理员身份登录;
2. sequence_owner必须为大写,不管你的用户名是否大写。只有大写才能识别。