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
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 is an extent ? : Sql dba
Is pl sql better than sql?
What is sql injection owasp?
how to select first 5 records from a table? : Sql dba
Can a foreign key be null?
what are the types of join and explain each? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
How much does sqlite cost?
Sql technical questions
What is a trigger word?
What are local and global Indexes and where they are useful.
What are the key differences between SQL and PL SQL?
Which constraints we can use while creating database in sql?
Difference between table function and pipelined function?
How do I find sql profiler?