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.

Write a syntax for update query in oracle?

1073

---

Explain the difference between sap and oracle?

1085

---

Why is oracle so popular?

1053

---

What is null value in oracle?

1157

---

How to use subqueries with the in operator using oracle?

1137

---

How to filter out duplications in the returning rows using oracle?

1066

---

How to join two tables in a single query using oracle?

1052

---

What would you do with an in-doubt distributed transaction?

2045

---

What are the numeric comparison operations?

1167

---

Can we protect our pl/sql source code?

1082

---

How to write date and time literals in oracle?

1043

---

What is the use of aggregate functions in oracle?

1071

---

Where are the settings stored for each instance in oracle?

1152

---

What is ADDM Advisor in Oracle?

1222

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

---