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
17263 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

What is difference between hql and sql?

992

What if we write return in procedure?

1336

Can a commit statement be executed as part of a trigger?

998

Is sql a backend language?

1043

Why do we use cursors?

921

Why is a primary key important?

968

What is keys and its types?

1022

How do you write an inner join query?

892

How do you explain an index number?

1023

Mention what plvcmt and plvrb does in pl/sql?

1062

What is dynamic query?

915

What is the use of function in sql?

1029

What does count (*) mean in sql?

1519

Are stored procedures faster than dynamic sql?

982

How do you go back in sql?

942