I NEED PL/SQL PROCEDURE we can't use sqlplus,why because we can�

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

Question Posted / madhu

7 Answers
17255 Views
Polaris, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is a primary key example?

902

How do I run a pl sql program?

1064

Is join an inner join?

896

What are the benefits of stored procedures?

997

what is the difference between a local and a global temporary table? : Sql dba

1004

Does truncate table reset auto increment?

939

what is a control file ? : Sql dba

988

Are stored procedures compiled?

871

What is time based sql injection?

901

What is materialized view in sql?

871

What is secondary key?

881

Is there any restriction on the use of union in embedded sql?

1100

Is sql open source?

915

Why is sql better than hql?

920

what's the difference between a primary key and a unique key? : Sql dba

971