select A.cities,B.countries from A,B; where Table A has col cities w

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

Question Posted / cheeku

Answer Posted / cheeku

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

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

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

List the types of joins used in writing subqueries?

998

How to open and close an explicit cursor in oracle?

1058

What is key preserved table?

1021

What is the difference between a user and a schema in oracle?

1034

How to assign a table row to a record variable?

1041

What is recovery manager(rman) backup in Oracle?

1185

What is meant by an index?

1145

Difference between inner join vs where ?

1036

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2145

How to delete all rows a table in oracle?

1068

How to create a table index in oracle?

1134

How a database is related to tablespaces?

1032

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2209

how the indexes are stored in the Oracle Database?

2271

Explain what are the advantages of views?

1069