Who i will insert 1 lacks record in a Database table
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 we get field detail of a table?
What is meant by recursive hints ?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the difference between a user and a schema in oracle?
How do you rate yourself in oracle and sql server ?
What is an oracle user role?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to add a new column to an existing table with a default value?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is a nested table?
How to convert raw data type into text in oracle? Explain
What are the different windows events activated at runtime ?