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

Home -> Community -> Usenet -> c.d.o.misc -> Re: NEWBIE needs help on autonumber

Re: NEWBIE needs help on autonumber

From: John Vinson <jvinson_at_cyberSPAMLESShighway.net>
Date: Sun, 07 Mar 1999 02:50:44 GMT
Message-ID: <36e2e960.35433112@news.cyberhighway.net>


On Sun, 07 Mar 1999 02:19:17 GMT, nbcouch_at_envisionet.net (Nicholas Couch) wrote:

>>Take a look at BeforeInsert Triggers. Some things that Access does
>>"out of the box" require programming in Oracle...
>>
>
>But look at the flexibility you get in return! You can have a sequence without the
>trigger, which is useful in multi-table insert situations. You can disable the trigger
>temporarily if you need to. You can set the sequence to start at any value you like,
>incrementing likewise, etc etc.

Oh, no argument. I use both products; they both have their strengths and weaknesses. Received on Sat Mar 06 1999 - 20:50:44 CST

Original text of this message

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