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
- 6143 Views
- I also Faced
- E-Mail Answers
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
What is db driver?
What's the difference between 'union' and 'union all' ?
What do database languages do?
Explain 3nf?
How is foreign key commands related to primary key?
What are the characteristics of dbms?
What do you understand by the view and mention the steps to create, update and drop a view?
Enlist the advantages of normalizing database.
What are cursors give different types of cursors?
What is a string in database?
How can I join two tables in database?
What is the difference between a delete command and truncate command?
What is the main purpose of normalization?
What is the main purpose of a database?
What are the parts of a table?
