Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12878 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 dictionary cache ?
Explain the blob datatype?
What is the usage of analyze command in oracle?
What are the uses of linked server and explain it in detail?
Is oracle a relational database?
What is Library Cache in Oracle?
what is a Nested Loop join?
How do I know if oracle is installed on windows?
what diffrence between function and procedure?
How to connect ms access to oracle servers?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to assign data of the deleted row to variables?
Oracle General 
