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
- 17464 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
What is error ora-01000: maximum open cursors exceeded
How to move files from one directory to another in pl sql?
Can I join the same table twice?
What is sql lookup?
What is sql*loader and what is it used for? : aql loader
What is the difference between sum and count in sql?
What is an inconsistent dependency?
how to rename an existing table in mysql? : Sql dba
Is it possible to pass parameters to triggers?
What is the difference between join and natural join?
How do I run a pl sql program?
Can we insert in view in sql?
How does stored procedure reduce network traffic?
What is bind reference and how can it be created?
What is embedded sql with example?
