I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
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;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the use of inctype option in exp command.
Whether any commands are used for months calculation? If so, what are they?
Describe varray?
How to convert characters to numbers in oracle?
What are the limitations of check constraint?
List out the difference between commit, rollback, and savepoint?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What the is the diff between local index and global index. give some example.
How to Truncate Table in Oracle
what is dynamic SGA and static SGA
How to use regular expression in pattern match conditions in oracle?
how to make an oracle object
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Explain what are the uses of rollback segment?
What is the oracle implicit cursor?