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
- 15225 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 start sql profiler?
what is transaction? : Sql dba
Why do we need databases?
Are subqueries faster than joins?
How can you fetch first 5 characters of the string?
What does seeding a database mean?
How do you declare a constant?
Name the operator which is used in the query for pattern matching?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How do I tune a sql query?
how is myisam table stored? : Sql dba
How do I order by ascending in sql?
What is the purpose of using pl/sql?
What is the difference between a primary key and a clustered index?
What does desc stand for?
