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.

Differentiate between pre-select and pre-query?

1106

---

How to create a stored function in oracle?

1105

---

How to drop a stored function?

1137

---

How to connect to oracle using service name instead of sid?

1024

---

What is a trigger oracle?

1084

---

Explain the features of oracle?

1041

---

Explain view?

1030

---

How to run queries on external tables?

1045

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1019

---

What is save point in oracle database?

1291

---

How to manage transaction isolation level?

1003

---

How do I call oracle stored procedures that take no parameters?

1111

---

How to drop an index?

958

---

What is the difference between postgresql and oracle?

1048

---

What do you mean by cdb and pdb in oracle 12c?

1059

---