insert [message #292937] |
Thu, 10 January 2008 03:53  |
oracle_coorgi
Messages: 188 Registered: September 2006 Location: INDIA-karnataka
|
Senior Member |
|
|
hi
i have table tab01 col1,col2
i want to insert 50,0000 records into tab01 dummy value eg... values('aaaaa','bbbbb');
thx
|
|
|
Re: insert [message #292942 is a reply to message #292937] |
Thu, 10 January 2008 03:57   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
1. What makes you think that this is an expert question?
2. What have you tried already, or do you think that we are here to do your homework for you?
|
|
|
Re: insert [message #292948 is a reply to message #292942] |
Thu, 10 January 2008 04:09   |
oracle_coorgi
Messages: 188 Registered: September 2006 Location: INDIA-karnataka
|
Senior Member |
|
|
hi thx pablolee for the quick response;
this is not a home work or ...
i just need to know becoz.. in app.. we are inserting thousands of record in one save.
i just want to get a query which i can test the database side (preformance wise )
thx ..
|
|
|
|
|
|
Re: insert [message #292959 is a reply to message #292950] |
Thu, 10 January 2008 05:00   |
oracle_coorgi
Messages: 188 Registered: September 2006 Location: INDIA-karnataka
|
Senior Member |
|
|
hi
as i was into many things here i needed your help ..
i think you posted this answer in your perious issues
the answer i was looking for was..
SELECT DBMS_RANDOM.value( '25', 0 ) from dual
thx lasts share ....
|
|
|
Re: insert [message #292960 is a reply to message #292959] |
Thu, 10 January 2008 05:04   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Yes I posted, last week, don't you search before posting?
And what you posted does not fit your requirement (value return a number not a string) and answer you got is more serious and appropriate.
Why don't you posted it as it?
And why should I have to insist for you to post something?
You know how to post your questions, why don't you know how to forward the solutions?
Regards
Michel
[Updated on: Thu, 10 January 2008 05:06] Report message to a moderator
|
|
|
Re: insert [message #292961 is a reply to message #292960] |
Thu, 10 January 2008 05:12  |
oracle_coorgi
Messages: 188 Registered: September 2006 Location: INDIA-karnataka
|
Senior Member |
|
|
INSERT INTO tab01( col1, col2 )
SELECT DBMS_RANDOM.STRING( 'L', 5 ), DBMS_RANDOM.STRING( 'L', 5 )
FROM dual
CONNECT BY LEVEL <= 500000;
COMMIT;
|
|
|