ORACLE 对象查询-序列

SQL> select SEQUENCE_NAME from USER_SEQUENCES;

SEQUENCE_NAME
------------------------------
LABOUR_NO_SEQ
LODGE_SEQ
OBJ_IDS
POID_IDS2
STAT_TEMP_SEQ

SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
SET LONG 999999
SET PAGESIZE 1000
SELECT DBMS_METADATA.GET_DDL('TABLESPACE','PIN01') FROM DUAL;