Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12849 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 |
Explain drop constraint oracle?
What is a View ?
List the parts of a database trigger.
What is the relation of a user account and a schema in oracle?
What is oracle sid?
how to hide the stored procedure inside a package
What is bulk load in oracle?
What are a cluster and non-cluster index?
How do I spool to a csv formatted file using sqlplus?
What is Water Mark in Oracle?
List the various oracle database objects?
What is concurrency in oracle?
Oracle General 
