в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T10:01:16Z

1 версия

Новая страница

==Query user_sequences table==



<source lang="sql">

SQL>
SQL> SELECT sequence_name, increment_by,
2 DECODE(cycle_flag,"y"," cycle","n", "nocycle", "nocycle")
3 cycle_flag,
4 DECODE(order_flag,"y"," order","n", "noorder", "noorder")
5 order_flag,
6 max_value, min_value, cache_size, last_number
7 FROM user_sequences
8 where rownum < 50
9 ORDER BY sequence_name;
no rows selected
</source>

==Query USER_SEQUENCES table to get the sequence info==



<source lang="sql">
SQL>
SQL> CREATE SEQUENCE StudentNumSeq
2 INCREMENT BY 1
3 START WITH 1100
4 MAXVALUE 99999
5 NOCACHE
6 NOCYCLE;
Sequence created.
SQL>
SQL> SELECT sequence_name, increment_by, cache_size, last_number
2 FROM USER_SEQUENCES
3 WHERE sequence_name ="STUDENTNUMSEQ";
SEQUENCE_NAME INCREMENT_BY CACHE_SIZE LAST_NUMBER
------------------------------ ------------ ---------- -----------
STUDENTNUMSEQ 1 0 1100
SQL>
SQL>
SQL> drop sequence StudentNumSeq;
Sequence dropped.
SQL>
SQL>

</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/System Tables Views/USER SEQUENCES - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия