Answer Posted / katty

When data is to be retrieved from one table based on the condition from another table subquery is used 
When the data is to be retrieved from both the tables join is used

How can I see all tables in oracle?

949

---

What is Virtual Private Database in Oracle?

1014

---

What is save point in oracle database?

1238

---

What is object data modeling?

903

---

What is oracle data type?

900

---

How to delete a column in an existing table in oracle?

1008

---

Is the After report trigger fired if the report execution fails ?

2876

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2243

---

How to use "in out" parameter properly?

997

---

How to load excel data sheet to oracle database

964

---

How to convert times to characters in oracle?

976

---

Explain about your project and its relation to the current job position you are applying to?

942

---

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

962

---

How to create a single index for multiple columns?

976

---

How to sort the query output in oracle?

967

---