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 restrictions can you apply when you are creating views?

476


What is the main purpose of triggers in database?

453


What do you understand by correlated subqueries in dbms?

562


What is cold backup and hot backup (in case of oracle)?

476


What is procedure in database?

519






What are the four types of database?

488


What is a key in dbms?

489


Define dbms.

511


What are the disadvantage in file processing system?

514


What is called dbms?

496


Explain the term ‘relations’?

484


Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1484


What is the normal procedure followed by a java client to access the db?

436


what are the different kinds of indexing?

501


What is pdo database?

484