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
- 15208 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 add a database to sql?
What is a record in a database?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
What is an inconsistent dependency?
what is a record in a database ? : Sql dba
what is a composite primary key ? : Sql dba
Why do we use procedures in pl sql?
What is the use of nvl function?
What is oracle pl sql developer?
explain access control lists. : Sql dba
what is table? : Sql dba
what is an index? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is record type in pl sql?
