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: using sequences in triggers to generate identities

Re: using sequences in triggers to generate identities

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 23 Apr 2007 11:19:05 -0700
Message-ID: <1177352345.789556.155650@n59g2000hsh.googlegroups.com>


On Apr 23, 12:47 pm, if <filip1..._at_gmail.com> wrote:
> Hi,
>
> ';m coming from a db2 background.
> I was wondering if in Oracle there is any performance (or other)
> difference between using a sequence in insert statements and using an
> insert trigger to do the same job.

The only difference is that by employing a trigger a small overhead is added - the equivalent of making a PL/SQL call. (btw, is somebody else using google groups here? is anybody else loosing his/her posts as well?) Received on Mon Apr 23 2007 - 13:19:05 CDT

Original text of this message

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