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

Home -> Community -> Usenet -> c.d.o.tools -> Increase userid when insert

Increase userid when insert

From: <henrik_at_partitur.se>
Date: 2000/05/16
Message-ID: <8fs48a$o5h$1@nnrp1.deja.com>#1/1

Hi
I want to make a trigger that increase the userid with one every time someone inserts something into the table. And I want to make the trigger when creating the table.

As I understand you can't use the sequence.nextval..or?

Thanks

Henrik

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 16 2000 - 00:00:00 CDT

Original text of this message

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