对象类型(索引还是约束)
select object_type from user_objects where object_name=''
查看某表的约束条件
select constraint_name, constraint_type,search_condition, r_constraint_name from user_constraints where table_name = upper('&table_name');
查看表的索引
select index_name,index_type,table_name from user_indexes where table_name='FE_SECURITY_MARKET';
select * from user_ind_columns where index_name=upper('PK_FE_SECURITY_MAR');
序列号下一个
SELECT tab_audit_sequ.nextval FROM DUAL;