有没有办法检索现有oracle-sql db模式中定义的所有序列?
理想情况下,我想使用这样的东西:
SELECT * FROM all_sequences WHERE owner = 'me';
这显然不起作用.
试试这个:
SELECT object_name FROM all_objects WHERE object_type = 'SEQUENCE' AND owner = '<schema name>'
是:
select * from user_sequences;
您的SQL几乎也是正确的:
select * from all_sequences where sequence_owner = user;