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
- 15209 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / yankee
Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.
| Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
Is foreign key mandatory?
What is bind variable in pl sql?
How do you use collections in procedure to return the resultset?
what are the different functions in sorting an array? : Sql dba
explain normalization concept? : Sql dba
What is sql table?
What is a dynamic query?
What is varchar data type in sql?
Can dml statements be used in pl/sql?
What are analytical functions in sql?
What are local and global variables and their differences?
is mysql query is case sensitive? : Sql dba
What is difference between sql function and stored procedure?
describe transaction-safe table types in mysql : sql dba
What is sequence in sql?
