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 |
1.display list of all users from ur data base.what is the query?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is proxy method?
what is the difference between dbms and rdbms?
How to use "startup" command to start default instance?
What are joins, explain all types of joins?
Explain view?
What are oracle functions?
how to store only time in a data base table
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
how will I find the first 5 highest salaried employees in each dept in oracle.