Re: adding 1000's new rows?

Sure,

create table testdata as (select object_name,object_id,created from dba_objects);

Now you have a table with 1000's of rows, containing a NUMBER , a VARCHAR2 and a DATA column, of which the first 2 columns are completely unique, while the third is not quite unique, but contains 1000 of different values.

The data dictionary is a great place to get some test data.....just have a look at all the other DBA_* views.

• Kenneth Koenraadt

>david spaisman wrote in message <3DBEC821.94993490_at_earthlink.net>...
>>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 - 13:05:50 CST