Interested to Buy Any Domain ? << Click Here >> for more details...
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
- 5 Answers
- 16823 Views
- I also Faced
- E-Mail Answers
Answer Posted / hima bindu
Hi
If u want to import the data which is in .xls file to
oracle data base then first create temporary table in
database then write insert statements in excel file using
functions then execute that scripts into toad. Then the
data in excel sheet is imported to data base.
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
What is a parameter file in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to start instance with a minimal initialization parameter file?
What are the predefined tablespaces in a database?
State and explain the different types of data models?
what is IDE,DMV in sql server?
How to pass parameters to procedures in oracle?
Briefly explain what is literal? Give an example where it can be used?
Can we protect our pl/sql source code?
How will you write a query to get a 5th rank student from a table student_report?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are the restrictions on external table columns?
What are the differences between interval year to month and interval day to second?
When do you get a .pll extension in oracle?
How to use subqueries in the from clause in oracle?
