Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12994 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 a nested table?
What language does oracle use?
Explain the different normalization forms?
How do we represent comments in oracle?
What is the use of file param in imp command?
How to call a trigger inside a stored procedure?Give an example.
What is using clause and give example?
How do we get field detail of a table?
How to find no of saturdays in a month using single sql ?
what is port in oracle? how is it related to database application.
What is the difference between substr and instr?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Oracle General 
