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
- 5998 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 are the four objectives of the selection of a data type?
Describe the types of keys?
What is an optimization and performance tuning and how does it really work in practical projects?
What are the various types of relationships in database? Define them.
Explain the advantages and disadvantages of a hierarchical database?
What is a 3nf table?
What is structure of dbms?
What is database management system(dbms)?
what is storage manager?
How to use multiple database server in back end ?
Segregate database technology's development.
Define entity set.
What is openedge workgroup rdbms?
What is the main difference between union and union all?
what are the different kinds of indexing?
