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
- 6015 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 a database in a website?
What is data independence and also explain its types?
How to change database dialect?
Explain environment of openedge?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
What are the different levels of abstraction in the dbms?
What is index hunting and how does it help in improving query performance?
When would you use a database?
Explain the different types of database keys?
What are records and fields in a database?
What is drivermanager getconnection?
Enlist ways to efficiently code transactions.
What is database management system(dbms) and why it is used?
Define sub-query.
What is file manager?
