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
- 5349 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What you know in mapping of erd to dfd?
What are the different types of keys in the database?
What is an extensible database?
What are the four objects in a database?
How to use events with zebedee, ssh or stunnel?
What is rdms?
Why is data modelling important?
What is difference between database and file?
What are the types of database?
what do u mean by canvases and alerts?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
How do you notify dbpak about stored procedure?
Explain the difference between primary and foreign key?
When should you consider denormalization?
What is 2nf in the dbms?
