Re: PL/SQL Brain Teaser -- Shouldnt be too difficult for an expert

tojo wrote:

> 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?

Sure looks like it to me which is why I didn't respond.

I would sure hope no one is doing this in any real application as it would be indicative of someone that didn't study database design and architecture.

Daniel Morgan Received on Wed Feb 05 2003 - 11:42:13 CST