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

What is graph sql?

972

Is primary key an index?

984

What is a temp table?

999

What is compiled query?

1014

What is the difference between sql and isql*plus?

1071

What is a recursive stored procedure?

1158

What is a database? Explain

1092

Do we need commit after truncate?

1063

What is the difference between subquery and correlated query?

1042

What are the different schemas objects that can be created using pl/sql?

1002

What is normalization sql?

1037

What are tables and fields?

1013

How to run pl/sql statements in sql*plus?

1060

Explain the update statement in sql

968

what are the 'mysql' command line arguments? : Sql dba

1120