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?
Answer Posted / 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 |
Post New Answer View All Answers
Define RDBMS.
What are the benefits of database management system?
What is a relation schema?
What do you understand by aggregation and atomicity?
what is scan listener.
What is the use case where we can use stretch database?
Which two can be implemented as a centrally located logical architecture?
Enlist the cursor types.
Why do we study dbms?
What is a Built_in subprogram ?
How to do replication of firebird databases?
What are vdl and sdl?
Do I need ccp4?
Explain Relational Algebra in RDBMS
I have a table which has lot of inserts, is it a good database design to create indexes on that table?