Probably, u have to save the file in ur hard disk(namely in ur D drive) f

I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS

Question Posted / yankee

7 Answers
17571 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / yankee

Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.

Is This Answer Correct ?

2 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1099

Can a trigger call a stored procedure?

1075

What is the plv (pl/vision) package offers?

1054

what is try_catch block in procedure

1755

Is oracle sql free?

991

Which software is used for pl sql programming?

993

Why is %isopen always false for an implicit cursor?

1114

What are sql indexes?

1004

What is the use of procedures?

976

what is blob? : Sql dba

1155

what is subquery? : Sql dba

1141

What is meaning of <> in sql?

1074

what are the different type of normalization? : Sql dba

1032

Why is sql better than hql?

999

What is a clob in sql?

1026