Home » SQL & PL/SQL » SQL & PL/SQL » insert
insert [message #292937] Thu, 10 January 2008 03:53 Go to next message
oracle_coorgi
Messages: 185
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 Go to previous messageGo to next message
pablolee
Messages: 2834
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 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
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 #292949 is a reply to message #292948] Thu, 10 January 2008 04:09 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
OK, so what have you tried so far?
Re: insert [message #292950 is a reply to message #292937] Thu, 10 January 2008 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And as you have posted this question in many forums and as usual you will not share the answer you will get, I don't think it is worth to answer you.

It is my opinion.

Regards
Michel
Re: insert [message #292956 is a reply to message #292950] Thu, 10 January 2008 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Indeed, it receives an answer in another forum and didn't forward it here.

Bad guy!

Regards
Michel
Re: insert [message #292959 is a reply to message #292950] Thu, 10 January 2008 05:00 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
oracle_coorgi
Messages: 185
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;
Previous Topic: A count query problem.
Next Topic: counting records in text file using utl_file
Goto Forum:
  


Current Time: Fri Dec 02 22:46:22 CST 2016

Total time taken to generate the page: 0.07059 seconds