1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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?

Question Posted / gurusuryas

Answers were Sorted based on User's Feedback



I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database ..

Answer / shamimul

An excel file cannot store more than 64K records.

To load an excel file, we will have to convert it to a
delimited format. the load it using sqlldr

Is This Answer Correct ?    5 Yes 2 No

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database ..

Answer / bibekananda pradhan

An excel file cannot store more than 64K records.

To load an excel file, we will have to convert it to a
delimited format. the load it using sqlldr

Is This Answer Correct ?    2 Yes 0 No

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database ..

Answer / 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

More Database Management Interview Questions

explain the man feature of RDBMS ?

3 Answers  

How do you link a spreadsheet to a website?

0 Answers  

What is the license for clipper?

0 Answers  

Is this statement true or false? All databases must be in third normal form?

0 Answers  

what is dba_segment

4 Answers  




IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

What do you understand by e-r model?

0 Answers  

Enlist various types of interactions created by dbms?

0 Answers  

can Constraints cannot be exported through EXPORT command ?

2 Answers   Grasim, Oracle, Suvidha,

Why do we need to use a database?

0 Answers  

What are the characteristics of database?

0 Answers  

What is the use of drop command and what are the differences between drop, truncate and delete commands?

0 Answers  

For more Database Management Interview Questions Click Here
Categories