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
- 6007 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Describe the difference between data and database administration.
What is difference between database and server?
Define denormalization.
What are the limitations of using a model?
Describe and contrast sql and qbe.
How to find the size of database?
Why is the use of dbms recommended?
How do you exit a database?
What is a system concept?
State three differences between Dbms and Rdbms?
Describe the difference between homogeneous and heterogeneous distributed database.
Why is database important?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
