Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying rows
Russ Whiteman wrote:
> You could use a before_insert trigger on the table to whatever value is in
> the primary key column with the next sequence number, then your query would
> not need to specify column names. This has the downside of assuming that
> you always want duplicate row inserts to succeed, but nothing's perfect.
How would I construct this trigger? I want to be able to insert "normal" rows as well.