I have one Excel file with 80,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
How can i do that?

Answer Posted / ur_momma

Sqlldr is kinda oldschool these days, external tables is
the way to do it with the delimited file.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of joins in the sql?

612


Explain the difference between dbms and rdbms?

591


How big is a big database?

557


What are types of dbms?

620


what are the advantages of using them.

579






Why do we use databases?

537


Explain what are called fat clients and fat servers?

560


How to write udf s in delphi?

602


I have a table which has lot of inserts, is it a good database design to create indexes on that table?

590


How is rdbms different from dbms?

601


What is query in rdbms?

579


Is database a storage?

583


Explain what are the two types of oltp?

561


What integrity rules exist in the dbms?

585


What is the full form of rdbms?

565