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?
- 3 Answers
- 5345 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the three types of databases?
What are views in dbms?
Where is database data stored?
Enlist some commands of dcl?
What is normalization and why it is used?
What are the four objectives of the selection of a data type?
Enlist various types of interactions created by dbms?
Explain the Logical Schema of Database
What is normalization and what are the different types of normalization?
What is a functional dependency in the dbms?
Define normalization.
How do you start a database?
Explain what are the types of transparencies?
What are the advantages of database?
In which phase of mload can I use .filler?
