Answer Posted / saiki

SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME
FROM COUNTRY,CITY
WHERE COUNTRY.COUNTRY_NAME = CITY.COUNTRY_NAME
GROUP BY COUNTRY.COUNTRY_NAME;

What is a trigger and what are its types in oracle?

531

---

How to retrieve the count of updated rows?

568

---

How to write numeric literals in oracle?

602

---

What are the limitations of check constraint?

560

---

Does facebook use oracle?

564

---

---

what are the advantages of running a database in archive log mode?

1727

---

What is using clause and give example?

579

---

How do I limit the number of oracle database connections generated by weblogic server?

543

---

What is the exact use of Collections?

1674

---

State any two functions of oracle?

630

---

What is a snapshot log?

557

---

What are the attributes of cursor?

583

---

How do I find my oracle client driver version?

522

---

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

547

---

State all possible different index configurations a table can possibly have?

560

---