Oracle中序列、索引、触发器查询

序列查询

查询当前用户下序列：select * from user_sequences;

查询序列名：select SEQUENCE_NAME from user_sequences;

查询指定所属者序列：select SEQUENCE_NAME,SEQUENCE_OWNER from dba_sequences where SEQUENCE_OWNER='OWNER'; （注：OWNER得大写才行，OWNER差不多等同于用户）

导出序列：select  'create sequence ' ||sequence_name||   
        ' minvalue ' ||min_value||   
        ' maxvalue ' ||max_value||   
        ' start with ' ||last_number||   
        ' increment by ' ||increment_by||   
       ( case  when cache_size= 0  then  ' nocache'   else   ' cache ' ||cache_size end) || ';'   
from dba_sequences where sequence_owner= 'OWNER' ; （OWNER作用同上）

删除序列：drop SEQUENCE sequence_name;

---

索引查询

查询当前用户下索引名：select INDEX_NAME from user_indexes;

删除索引：drop index INDEX_NAME；

---

触发器查询

查询触发器：Select object_name From user_objects Where object_type='TRIGGER';

Select TRIGGER_NAME From user_triggers;

删除触发器：drop TRIGGER TRIGGER_NAME；（TRIGGER_NAME为触发器名）