Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12716 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 to display the hierarchy of employee and managers without using connect by prior.
how do get database name at sql prompt?
How to define an oracle cursor variable?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
difference between oracle8i and oracle9i
What the is the diff between local index and global index. give some example.
How much memory your 10g xe server is using?
How to execute a stored procedure in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is SQL Tuning Advisor in Oracle?
Can sub procedure/function be called recursively?
Oracle General 
