Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger with sequence

Re: Trigger with sequence

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 18 May 2005 10:02:13 -0700
Message-ID: <bf4638050518100286c3aa5@mail.gmail.com>


On 5/17/05, Kean Jacinta <jacintakean_at_yahoo.com> wrote:
>
>
> User accidently deleted id 3, and i want to manully
> create the id 3 again.
>
> insert into myclass (id, name) values (3, 'BU');
>
> I Found that , this id 3 is not created but a new id
> is created by the trigger as 5 . Any workaround for
> tis ?

see http://www.freelists.org/archives/oracle-l/04-2005/msg00860.html

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 18 2005 - 13:07:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US