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 / madhu
I NEED PL/SQL PROCEDURE
we can't use sqlplus,why because we can't upload the data
in single statement,So we need pl/sql procedure
or else dump the data using with sql loader
by using command prompt in SQL LOADER
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is a primary key example?
How do I run a pl sql program?
Is join an inner join?
What are the benefits of stored procedures?
what is the difference between a local and a global temporary table? : Sql dba
Does truncate table reset auto increment?
what is a control file ? : Sql dba
Are stored procedures compiled?
What is time based sql injection?
What is materialized view in sql?
What is secondary key?
Is there any restriction on the use of union in embedded sql?
Is sql open source?
Why is sql better than hql?
what's the difference between a primary key and a unique key? : Sql dba