I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
- 3 Answers
- 5224 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
What is Data Dictionary Cache in Oracle?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How can we find out the current date and time in oracle?
What is sequence?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What is the data type of dual table?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
Why packages are used in oracle?
How to revoke create session privilege from a user in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
State some uses of redo log files?
Oracle General 
