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
- 6017 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 the purpose of queries in a database?
Explain the terms specialization and generalization.
What is Database Management System?
Define checkpoint.
What is difference between database and file?
How to know the Architecture of the Database
What are the components of a database management system?
What is unique key in dbms?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What are the drawback of rdbms?
What is database management definition?
List few ways to code transactions in an efficient manner?
What are the properties of a primary key in DBMS?
What are the different technologies used to access Database from Visual Basic?
