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
- 15224 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
What are aggregate and scalar functions?
Why truncate is faster than delete?
What is mutating sql table?
How do you run a query?
What is the process of debugging?
What are sql injection vulnerabilities?
What is user in sql?
What is your daily office routine?
What does trigger mean in slang?
What is the need of merge statement?
Is left join same as join?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Which are sql * plus commands?
what are date and time data types? : Sql dba
what is auto increment? : Sql dba
