Home » SQL & PL/SQL » SQL & PL/SQL » How to generate sequence number in a column.....
How to generate sequence number in a column..... [message #18869] Tue, 19 February 2002 10:25 Go to next message
Satya
Messages: 36
Registered: January 2001
Member
hai,

I am new to oracle. I have a table in which "ID Column" should automatically generate a sequence number itself whenever i insert in the table. In postgresql there is a datatype called "SERIAL". Is there anything in oracle. If not how can i achieve it.
Thanqs in advance for the guys who try to solve my problem.
bye
satya

Report message to a moderator

Re: How to generate sequence number in a column..... [message #18870 is a reply to message #18869] Tue, 19 February 2002 10:36 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
1) create sequence

SQL> create sequence myseq start with 1;

2) create trigger on table

create or replace trigger trig1
before insert on yourtable
fro each row
begin
select myseq.nextval into :new.id from dual;
end;
/

Report message to a moderator

Previous Topic: COMMIT inside a PL/SQL script
Next Topic: core dump, please help!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 04:35:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.