Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17801 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
Which command is used to delete a package?
What makes a good primary key?
Is inner join faster than left join?
Why sql query is slow?
What is acid property in a database?
What does t sql mean?
Explain table and field in sql?
What is the difference between a query and a report?
What's the difference between inner join and left join?
How does join work in sql?
what are the t string functions available in tsql? : Transact sql
how to write date and time literals? : Sql dba
What is offset in sql query?
How can we make an if statement within a select statement?
Can we use views in stored procedure?
