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
- 5871 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 database management system(dbms) and why it is used?
What is database implementation?
How does a database partition work?
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
How can I access my database remotely?
What is openedge translation manager?
What is primary key in dbms?
What is the purpose of queries in a database?
What is database normalization? Explain types of it.
Explain the terms database and dbms. Also, mention the different types of dbms.
What are the steps in creating a database?
Is there a database program for mac?
What is the quickest sorting method to use?
What is 1nf 2nf 3nf in dbms?
Who invented schema theory?
