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
17550 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 record in a database ? : Sql dba

1061

What is the requirement of self-join?

1130

What are sql ddl commands?

1090

What are schema-level triggers?

1101

Differentiate between pl/sql and sql?

1148

What is a boolean in sql?

980

what is bcp? When does it used? : Sql dba

988

Does truncate require commit?

972

Can a select statement fire a trigger?

1157

What is materialized view. What are different methods of refresh?

1393

how to shutdown mysql server? : Sql dba

1101

what is a database? : Sql dba

1169

What is the use of index in sql?

1017

What is the location of pre_defined_functions.

1166

How many tables can a sql database have?

977