Please use sqlldr on UNIX or Ora Loader software to load any kind of file(

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 / sajid siddiki

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

Answer Posted / sajid siddiki

Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use cursors?

994

What is the max nvarchar size?

985

What is a composite primary key?

1099

What is a data definition language?

1144

What are sql*plus environment variables?

1099

How do I run a program in pl sql?

1008

What are procedures used for?

991

Difference between table function and pipelined function?

1028

how to drop an existing table in mysql? : Sql dba

1051

How do we accept inputs from user during runtime?

1071

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1076

How run sql*plus commands that are stored in a local file?

1065

Why we use join in sql?

980

Explain raise_application_error.

1105

what is the difference between clustered and non clustered index in sql? : Sql dba

1131