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: Nicholas Couch <nbcouch_at_envisionet.net>
Date: Sun, 07 Mar 1999 17:50:26 GMT
Message-ID: <36e2bbce.4620868@mindmeld.idcomm.com>


On Sun, 07 Mar 1999 02:50:44 GMT jvinson_at_cyberSPAMLESShighway.net (John Vinson) wrote:

>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.
>

All databases are equal, but some databases are more equal than others. ;-)

Say, don't I remember you from the old Access forum on Compuserve days? Received on Sun Mar 07 1999 - 11:50:26 CST

Original text of this message

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