00001.Oracle
2023-12-05 本文已影响0人
笑着字太黑
1.选择指定schema的所有sequence情报
SELECT * FROM DBA_SEQUENCES WHERE SEQUENCE_OWNER = 'xxx';
SELECT * FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'xxx';
SELECT * FROM DBA_SEQUENCES WHERE SEQUENCE_OWNER = 'xxx';
SELECT * FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'xxx';