Re: Several rows from Dual
From: Hans Mayr <mayr1972_at_gmx.de>
Date: Mon, 16 Feb 2009 00:58:35 -0800 (PST)
Message-ID: <47208fb7-a322-4156-9808-60c91eba20b4_at_s20g2000yqh.googlegroups.com>
Thanks Maxim! Another great answer.
Date: Mon, 16 Feb 2009 00:58:35 -0800 (PST)
Message-ID: <47208fb7-a322-4156-9808-60c91eba20b4_at_s20g2000yqh.googlegroups.com>
Thanks Maxim! Another great answer.
Robert: The context is as follows: A user analyses a couple of items. This analysis has to be done manually. For several items (ids 123,456,789) he identified one has to perform an insert. I was looking for an easy way to perform this insert so I take the result of the query above, do a join on it which returns the rows to be inserted. The point was to have a single point in the insert sql which had to be changed to do the operation.
Best,
Hans Received on Mon Feb 16 2009 - 02:58:35 CST