Re: populating a database..

From: Dante <dnotari_at_my-deja.com>
Date: Tue, 22 Jun 1999 10:12:52 GMT
Message-ID: <7knnj0$551$1@nnrp1.deja.com>

Francis,
I would use the view ALL_OBJECTS .. eg:

INSERT INTO A (col_name, col_number, col_date) SELECT owner || '.' || object_name, rownum, created FROM ALL_OBJECTS
WHERE ROWNUM <= 1000;

Regards
Dante

In article <376B0C09.D7000EF6_at_mail.lci.ufrj.br>, Francis <francis_at_mail.lci.ufrj.br> wrote:
> Please, i need some help!
> I have to populate an empty database with 1000 tuples
> which have to be generated automatically .
> example:
> Table A (number, name , date )
>
> is empty and i have to randomly generate data for this writing
> some script(I dont know how) .
> how i write a script to generate randomly data as number, string,
> date,..
> and insert these 1000 tuples into my database in once?
>
> im using personal oracle
>
> Thank you for helping me...
> Francis
> f_spiegel_at_hotmail.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 05:12:52 CDT