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
- 5899 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 actional flow mapping?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
Explain a database server?
Explain degree of a relation?
Explain the hierarchical database?
All questions related to Control m monitoring tool
What do you mean by denormalization?
How to open the database in exclusive mode?
Mention the different types of dbms.
Explain by listing some of dbms major advantages.
when All datafiles related to a Tablespace are removed ?
What is index hunting?
What do you mean by aggregate and scalar functions in dbms?
What are the steps to follow when preparing to create a table?
What is a functional dependency in the dbms?
