Oracle PL/SQL Tutorial/Sequences/Sequence Information

Материал из SQL эксперт
Перейти к: навигация, поиск

Get Sequence information from user_sequences table

   <source lang="sql">

SQL> CREATE SEQUENCE test_seq

 2  START WITH 10 INCREMENT BY 5
 3  MINVALUE 10 MAXVALUE 20
 4  CYCLE CACHE 2 ORDER;

Sequence created. SQL> SQL> select * from user_sequences where sequence_name="TEST_SEQ"; SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER


---------- ---------- ------------ - - ---------- -----------

TEST_SEQ 10 20 5 Y Y 2 10 SQL> SQL> SQL> drop sequence test_seq</source>


Getting Information on Sequences

You get information on your sequences from user_sequences.



   <source lang="sql">

SQL> desc user_sequences;

Name              Null?    Type
------------------
SEQUENCE_NAME     NOT NULL VARCHAR2(30)
MIN_VALUE                  NUMBER
MAX_VALUE                  NUMBER
INCREMENT_BY      NOT NULL NUMBER
CYCLE_FLAG                 VARCHAR2(1)
ORDER_FLAG                 VARCHAR2(1)
CACHE_SIZE        NOT NULL NUMBER
LAST_NUMBER       NOT NULL NUMBER</source>