Re: Several rows from Dual
Date: Mon, 16 Feb 2009 00:58:35 -0800 (PST)
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.
Hans Received on Mon Feb 16 2009 - 02:58:35 CST