Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Brain Teaser -- Shouldnt be too difficult for an expert
In article <MPG.18ab5890bb4e63f29896f3_at_news.t-online.de>,
Tojo_at_hotmail.com says...
ideas how to go about this?
> >
> Forget about the 30 parameters. Write the 30 values into a table
> (temporary if you want). You can put a unique constraint on this table's
> priority column. Then just INSERT INTO real_table SELECT * FROM
> temp_table. Wrap the whole thing in a transaction and go have a beer.
>
> -- Tom
>
It just occurs to me, is this homework?
Received on Wed Feb 05 2003 - 10:26:49 CST