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
- 15226 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / murthy
Please use the sql loader to upload the file into Oracle
database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a pragma statement?
How is data stored on a disk?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the difference between partitioning and sharding?
Explain what is table in a database?
What are the two parts of design view?
How do I sort a table in sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is procedure and function in sql?
how can we know the count/number of elements of an array? : Sql dba
What is primary and foreign key?
Why do we use procedures in pl sql?
Which are the different character-manipulation functions in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What are database links used for?
