If you are using SQL Developer one option is there for importing data from

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 / aryasen

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

Answer Posted / aryasen

If you are using SQL Developer one option is there for
importing data from excel/csv or any other files.
first u need to create table which contains all columns in
excel. then right click on that table it will give option
for import excel data to the table.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

973

How can you get sql*loader to commit only at the end of the load file? : aql loader

964

What is indexing oracle sql?

1024

Is oracle sql free?

926

What is column?

939

How long it takes to learn pl sql?

947

What is offset in sql query?

1068

Why do we use sqlite?

914

Does truncate release storage space?

1013

Is sql sequential or random?

980

What is nosql vs sql?

1121

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

966

What is pl sql package?

990

What is the syntax and use of the coalesce function?

1096

What packages(if any) has oracle provided for use by developers?

5715