Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
- 3 Answers
- 6463 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What is a connect identifier?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can multiple cursors being opened at the same time?
In the oracle version 9.3.0.5.0, what does each number shows?
How to assign data of the deleted row to variables?
How to start an oracle instance?
How to define a data field as not null?
What is different types of joins?
How to define a variable to match a table column data type?
What is oracle used for?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to create a table in a specific tablespace?
Explain the use of online redo log files in oracle.
How do you tell what your machine name is and what is its IP address?
