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
- 7 Answers
- 15748 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
How do I turn a list into a table?
Can a select statement fire a trigger?
How subquery works in sql?
What is the difference between sql and isql*plus?
How do you run a query?
What is a left join?
What are the most important characteristics of pl/sql?
Which join is like inner join?
what are the different type of normalization? : Sql dba
What is the difference between inner join and outer join?
what is the difference between union and union all? : Sql dba
Can we create clustered index without primary key?
What is the difference between delete and truncate commands?
Does sql full backup truncate logs?
Why procedure is used in sql?
