adding 1000's new rows?

Hello:

For testing if I have a new tableI need to nkow how to fill each of some columns wit differnt values. The columns could be varchar2 or number or even date defined..
I see how to add a sequenced identifieer(via a loop) but if there are other columns, I need to know how to fill them with data that's different.
While the update statement would provide a means to update all of the columns with the same values, I would like to nkow how to fill each column --let's say three- with different data . These columns are not sequenced generated values.

This is to test the table for select on different values.

Perhaps something with an ascii function but I am not sure how to code it. And there must be some other way but I am not sure how to do this. Does any one have any suggestions or routines to use to accomplish this random filling of three columns with different values?

David Received on Tue Oct 29 2002 - 08:38:59 CST