Re: Generating Huge Table

On 23 May 2005 02:06:57 -0700, "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:

>procedure blah (...,....,....)
>is
>begin
> insert into table ();
>exception
> when dup_val_on_index then
> update table ();
> when others then
> raise;
>end;
>/

This does work, but trapping an exception everytime is costly.

--
Sybrand Bakker, Senior Oracle DBA