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

Home -> Community -> Usenet -> c.d.o.server -> Re: How Can I Create a Table Which will has a AUTO ID Field ?

Re: How Can I Create a Table Which will has a AUTO ID Field ?

From: Greg Parsons <parsons_at_intermetrics.com>
Date: Mon, 27 Apr 1998 19:13:22 GMT
Message-ID: <3544D8D2.A5CD2FB7@intermetrics.com>


Hi,

    Check into creating a sequence and then a trigger before insert. Greg.

SEED wrote:

> Hi! Everybody
> This mail was from Taiwan. I had a question as Titile above.It's
> important for me to create a table with a AUTO ID Field , that means no
> matter when I insert or append a record , the database system will assist me
> to write a sequential number to that AUTO ID field. I'd been a user of MS
> SQL SERVER , it will do that kind function for me, Can Oracle do that ?
> Is there any one can assist me to solve such a problem ? mail me
> ,please! My mail was
> jasonch_at_ms1.hinet.net or
> 1596_at_cpc.org.tw
Received on Mon Apr 27 1998 - 14:13:22 CDT

Original text of this message

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