Answer Posted / cheeku

select A.cities,B.countries
from A,B;


where Table A has col cities
where Table B has col countries

What is oracle rownum?

683

---

What is rowid and rownum in oracle?

752

---

Explain the use of parfile option in exp command.

723

---

What is archive log in Oracle?

811

---

How to create id with auto_increment on oracle?

733

---

---

Can we save images in a database and if yes, how?

799

---

What privilege is needed for a user to create tables in oracle?

735

---

What is the quickest way to export a table to a flat file?

733

---

How to compare dates in oracle sql?

830

---

What are the ansi data types supported in oracle?

693

---

What are the different types of trigger and explain its various uses and functions?

728

---

Explain do view contain data?

756

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1743

---

How to create a new table in your schema?

788

---

How to use subqueries in the from clause in oracle?

800

---