Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger with sequence
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-lReceived on Wed May 18 2005 - 13:07:10 CDT
![]() |
![]() |