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
- 5870 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 |
How can you get the alternate records from the table in the sql?
How do I create a database?
What is different keys in dbms?
What is a data source (ds)?
If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains
How to prevent firebird.log file from filling up the disk partition?
Describe a subquery.
What is a join in the sql?
What are the main components of a database system?
What is the function of DML Compiler?
Mention few case manipulation functions in sql
Should database table names be capitalized?
-
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)
