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
- 6326 Views
- Microsoft, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Explain alias?
How to use attributes of the implicit cursor in oracle?
How to export data with a field delimiter?
What privilege is needed for a user to create views in oracle?
what are the default admin accounts in Oracle 10g ?
How would you begin to troubleshoot an ORA-3113 error?
What is an oracle user role?
What do you mean by a database transaction & what all tcl statements are available in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What do you mean by group by clause?
What are the arithmetic operations?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is the implicit cursor in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is tns name?
