Re: Help - Creating table with Sequence....

Hi:

You can create a sequence like the following one,

CREATE SEQUENCE <ur seq Name > INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1 NOCYCLE CACHE 20 NOORDER; Then Create a trigger like the one below.

CREATE or replace TRIGGER <ur trigger Name > BEFORE INSERT ON <ur table Name >
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
Begin
  select <ur seq>.nextval into :new.Entry_Number from dual ; End ;

Regards,
Prince.

In article <IYK65.186$Hs3.4104_at_news1.mts.net>,   "Newbie \(Joe \)" <jranseth_at_hotmail.com> wrote:
> Hello again,
> I need to create a table that has a sequence in it as the primary
> key.....I have no idea how, as I am new to Oracle (8i), and databases
> altogether (VB programmer).
> I heard that I have to create a database trigger...is this
 correct? How
> do I do that?
> The table will be something like the following...
>
> ENTRY_NUMBER Sequence, PK
> STATE_CODE Varchar2, FK (references state table)
> PRODUCT_CODE Varchar2, FK (references product table)
> ENTRY_OWNER Varchar2
> DATE_ENTERED Date (format DD-MON-YY hh:mi:ss am)
> ......other entry details, etc.
>
> Could I please get some help in creating this table? Sample SQL or
 detailed
> answers would be greatly appreciated as I am not really a database
 guru.
> Thank you so much for anyhelp...
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 29 2000 - 00:00:00 CDT