Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NEWBIE needs help on autonumber
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
![]() |
![]() |