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
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
What is union and union all keyword in sql?
what is data control language? : Sql dba
Is inner join same as self join?
How do I view a sql trace file?
What is date functions?
Is sql workbench free?
Explain the insert into statements in sql?
What is the use of %rowtype?
In what condition is it good to disable a trigger?
Can unique keys be null?
Can we rename a column in the output of sql query?
What are different types of statements supported by sql?
What is data control language?
Does varchar need length?
How do I make my sql query run faster?