Re: Sequence and inserting row

From: Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Date: Thu, 6 Dec 2001 03:17:41 +0100
Message-ID: <9uo8bi$40nq$1_at_as201.hinet.hr>


"Brian Dick" <bdick_at_home.com> wrote in message news:tegP7.23321$Xb7.203319_at_news1.wwck1.ri.home.com...
> When you manually insert the row, use INSERT (ID, ...) INTO ... SELECT
> MYSEQ.NEXTVAL, ... FROM DUAL to keep the sequence up to date.
>
> or
>
> Populate the ID column in an insert trigger that cannot be
circumvented.

Yes, this is right solution if you do know from which sequence the primary key column (ID) is populated but I don't know which is my sequence! Tell me the simplest way how to find out what is my sequence? From which sequence ID column in my table is populated? (There is a lot of sequences in DB model!)

--

Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Received on Thu Dec 06 2001 - 03:17:41 CET

Original text of this message