Do I have to reference this anywhere in my table definition? If not, how do
I create a primary key...or do I have to?
And what doe the OLD AS OLD NEW AS NEW mean? Is that old/new records?
Thank you so much for your help!!
<prince_kumar_at_my-deja.com> wrote in message
news:8jg0t3$jlg$1_at_nnrp1.deja.com...
> 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
