Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a nested table?

1003

What happens if you use a wrong connect identifier?

978

What are the advantages of oracle 12c?

1118

Please explain oracle left join with an example?

957

What is the difference between translate and replace?

1010

Why do we use bulk collect in oracle?

1009

what are archived logs?

2141

What is an Oracle index?

1601

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

What is the use of file param in imp command?

1114

How can windows applications connect to oracle servers?

982

Difference between pre-select and pre-query

1027

When system tablespace is created?

967

Explain integrity constraint?

1106

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1694