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
- 5997 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 |
What are different relationships existing in database?
What is concurrency control?
Oracle precompiler translates the EMBEDDED SQL statemens into ?
What does rdbms stand for?
Which database is faster?
What are the functions of database management system?
Explain what are called fat clients and fat servers?
Why are recursive relationships are bad? How do you resolve them?
In which phase of mload can I use .filler?
What are data modelling tools?
What is primary key in database?
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
-
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)
