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
- 5872 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 do you understand by database triggers?
What are the components of a database management system?
What will the SHOW_ALERT function returns ?
3 Answers College School Exams Tests, DSS,
Write a query to create a duplicate table with and without data present?
What do you understand by ‘atomicity’ and ‘aggregation’?
What is a candidate key in dbms?
Why do we need database normalization?
What is a database report?
What is stored in a database?
How the SMON process is used to write into LOG files ?
What is join? Mention its types.
What is trigger in dbms?
-
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)
