Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6138 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by a database?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
What is like operator for and what are wild cards?
What are cursors and what are the situations you will use them?
explain the term ‘attribute’?
Is access a database program?
Define phantom deadlock.
Where is data stored in database?
What are the steps in creating a database?
How do I add a file to a database?
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
What is a database report?
Mention some advantages of using dbms.
Explain primary key and composite key.
What is a functional dependency in the dbms?
