Who i will insert 1 lacks record in a Database table

Question Posted / sandeep

4 Answers
12702 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Who i will insert 1 lacks record in a Database table..

Answer / ramesh

you can go for bulk insert.

Is This Answer Correct ?

7 Yes

1 No

Who i will insert 1 lacks record in a Database table..

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

Who i will insert 1 lacks record in a Database table..

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

Who i will insert 1 lacks record in a Database table..

Answer / vawani sankar naik

USE SQL * LOADER.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Oracle General Interview Questions

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers HCL,

How do we get field detail of a table?

0 Answers

Is oracle an operator?

0 Answers

How to delete all rows a table in oracle?

0 Answers

What is COST-based approach to optimization ?

5 Answers

Why packages are used in oracle?

0 Answers

How can windows applications connect to oracle servers?