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
17456 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 trigger in sql? Explain

976

Explain the uses of a database trigger?

1016

What is foreign key and example?

917

What are transaction and its controls?

1022

What will you get by the cursor attribute sql%rowcount?

1018

What does seeding a database mean?

936

How do I view a table in sql?

993

Which is faster union or join?

948

Is delete faster than truncate?

994

Can we rollback truncate?

986

How to convert comma separated string to array in pl/sql?

1165

What are basic techniques of indexing?

1361

What are the different ddl commands in sql?

1133

what is the difference between union and union all? : Sql dba

1003

How does sql profiler work?

1002