| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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: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
 |
 |