Thursday, March 30, 2006

Insert from list of values

The following link from asktom has a beautiful way of inserting a list of values direclty into a table with just one insert statement

Click Here


In this technique rownum column is used to restrict the number of output rows retrived.

No comments: