Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12862 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 |
How do I know if oracle client is installed on windows?
What is a Data Segment ?
Can select statements be used on views in oracle?
How to work with data objects interactively?
What is recycle bin in Oracle?
Can you drop an index associated with a unique or primary key constraint?
How to write a left outer join with the where clause in oracle?
Explain an integrity constrains?
How are Indexes Update ?
Why does for update in oracle 8 cause an ora-01002 error?
What are the different types of trigger and explain its various uses and functions?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Oracle General 
