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 / abhishekjaiswal
yes, We can also import data in db by creating external table.So in this case, we can use sql plus too.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is table? : Sql dba
Name some usages of database trigger?
What is procedure and function in sql?
What are triggers and its uses?
Why is sharding used?
what is sql server agent? : Sql dba
What port does sql server use?
What is a native sql query?
What are the benefits of triggers?
What's the difference between inner join and left join?
Write a unique difference between a function and a stored procedure.
What is the difference between mdf and ndf files?
How to read xml file in oracle pl sql?
Which tcp/ip port does sql server run?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me