Home » SQL & PL/SQL » SQL & PL/SQL » creating incrementing PKs
creating incrementing PKs [message #39102] Sun, 16 June 2002 18:44 Go to next message
jermine
Messages: 1
Registered: June 2002
Junior Member
i need to create a primary key that is incrementing by 1... i dont know how to use TOAD and PL/SQL and i really new in using oracle...
hope u guys could help me.

thanks in advance
Re: creating incrementing PKs [message #39103 is a reply to message #39102] Sun, 16 June 2002 18:54 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a sequence and use it accordingly

SQL> create table test21
  2  (id number primary key,
  3  name varchar2(10));

Table created.

SQL> create sequence test21_seq
  2  start with 1 
  3  increment by 1;

Sequence created.

SQL> insert into test21 values
  2  (test21_seq.nextval, '&name');
Enter value for name: 1name
old   2: (test21_seq.nextval, '&name')
new   2: (test21_seq.nextval, '1name')

1 row created.

SQL> /
Enter value for name: 2name
old   2: (test21_seq.nextval, '&name')
new   2: (test21_seq.nextval, '2name')

1 row created.

SQL> /
Enter value for name: 3name
old   2: (test21_seq.nextval, '&name')
new   2: (test21_seq.nextval, '3name')

1 row created.

SQL> select * from test21;

        ID NAME
---------- ----------
         1 1name
         2 2name
         3 3name

Previous Topic: Invalid Month Problem
Next Topic: Re: Simple SQL Query.
Goto Forum:
  


Current Time: Thu Apr 25 22:15:23 CDT 2024