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
- 15211 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / sajid siddiki
Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to call shell script from pl sql procedure?
what is sp_pkeys? : Transact sql
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is a call statement? Explain with an example.
Is trigger a stored procedure?
What is difference between my sql and sql?
What are the advantages of indexing?
What is full form of rtm?
What is mutating trigger?
What is an ndf file?
What is bulk collect in pl sql?
How to handle bulk data?
What is program debugging?
Why trigger is used in sql?
Write an sql query to select all records from the table?
