Home » RDBMS Server » Server Administration » about sequence
about sequence [message #61835] Thu, 03 June 2004 19:48 Go to next message
ashokmote
Messages: 56
Registered: December 2003
Member
how would like to know about sequence.when we use this.please explain with example.
Re: about sequence [message #61844 is a reply to message #61835] Sun, 06 June 2004 04:05 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Sequences are used to generate sequential numbers. They are typically used to generate primary key values. Here is an quick example:

SQL> create table tab1(id number primary key, col2 varchar2(30));
 
Table created. 
 
SQL> create sequence seq1; 
 
Sequence created. 
 
SQL> insert into tab1 values (seq1.nextval, 'Value 1'); 
 
1 row created. 
 
SQL> insert into tab1 values (tab1_seq.nextval, 'Value 2'); 
 
1 row created. 
 
SQL> select * from tab1; 
 
        ID COL2 
---------- ------------------------------ 
         1 Value 1 
         2 Value 2 


For more info, read the Oracle SQL Reference Guide.

Best regards.

Frank
Previous Topic: Oracle 10g memory and cpu usage
Next Topic: how can i find hanged session
Goto Forum:
  


Current Time: Fri Sep 20 14:26:54 CDT 2024