SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME FROM COUNTRY,CITY WHERE COUNTRY

I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.

Question Posted / u.radha

Answer Posted / u.radha

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

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

751

Explain joins in oracle?

737

What is hot backup and logical backup?

787

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

762

What is set operator oracle?

701

Explain the use of control file?

848

How to count groups returned with the group by clause in oracle?

799

master table and child table performances and comparisons in Oracle ?

1878

How to define a procedure inside another procedure?

728

What is coalesce function?

751

How do you store pictures in a database?

731

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1673

Can sub procedure/function be called recursively?

727

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

757

What is an oracle user account?

739