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
17538 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

Explain the types of joins in sql?

1033

How to set up sql*plus output format in oracle?

1034

Can you have more than one key in a database?

932

Can we alter stored procedure?

986

Does inner join return duplicate rows?

974

What is information schema in sql?

1070

What is difference between cursor and trigger?

1070

what is unique key constraint? : Sql dba

1035

What are joins in sql?

1042

What does the hierarchical profiler does?

1057

what is offset-fetch filter in tsql? : Transact sql

944

What is package in pl sql?

1014

How do I order columns in sql?

1003

How do I create a sql script?

1097

What does subquery mean in sql?

1046