Yes, that too. I was joking, and maybe I should have emphasized the ;-), ;-), ;-) I think its a fast solution to generating rows of test data. Yet, similarly good ideas are shared frequently on lists, forums, books, and in specialized training as well as the symposium and conferences. I appreciate Jonathan Gennick's notes for those of us chained to the office, and unable to attend Hotsos this year. Thanks again Jonathan G!!! Regards, Mike Thomas On Thu, 10 Mar 2005 09:07:42 -0700, Barbara Baker <barb.baker@xxxxxxxxx> wrote: > Indeed???!? > I use it all the time: > create newtab as select * from oldtab where 1=2; -- //www.freelists.org/webpage/oracle-l