Who i will insert 1 lacks record in a Database table

Question Posted / sandeep

4 Answers
13004 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

How to load excel data sheet to oracle database

0 Answers

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers

Explain the blob datatype?

0 Answers

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers IBM,

Difference between join and a subquery?

8 Answers Base Automation, NMDC,

Explain rename?

0 Answers

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers

1.display list of all users from ur data base.what is the query?

3 Answers CGI, IBM,

How to define a data field as not null?

0 Answers

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers Philips,

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

0 Answers NIC,

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

0 Answers

For more Oracle General Interview Questions Click Here