Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12657 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 |
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the different types of databases?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Query to retrieve record for a many to many relationship ?
How to join two tables in a single query using oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to convert numbers to characters in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to use like conditions in oracle?
Explain the different normalization forms?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to load a large xml file?
Oracle General 
