Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12886 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kuldeep
CREATE TABLE A
(
ID NUMBER
)
NOLOGGING;
INSERT /*+APPEND*/ INTO A(ID)
SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL <= 100000;
COMMIT;
SELECT *
FROM A;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / milan
The qs is not quite clear....
Still I suppose u wana insert 1 lach record in database
table.
It is quite simple....
Just write a stored procedure for insert of 1 lakh
records,compile it and run...
U will b get 1 lakh records inserted in a single stroke...
| Is This Answer Correct ? | 3 Yes | 3 No |
What is a Shared SQL pool ?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How different is ms access and oracle?
What is oracle server autotrace in oracle?
What is a server parameter file in oracle?
How do I manually uninstall oracle client?
What are ddl statements in oracle?
Explain constraining triggers.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
how to produce numbers from 1 to 10 using dual table
How to install oracle odbc drivers?
What are the types of synonyms?
Oracle General 
