Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45072 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / katty
When data is to be retrieved from one table based on the condition from another table subquery is used
When the data is to be retrieved from both the tables join is used
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
What is a subquery?
Explain the use of parfile option in exp command.
what are the default admin accounts in Oracle 10g ?
Give the different types of rollback segments.
What are advantages of dateset in datastage?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What are the predefined tablespaces in a database?
What are a query and state the different types of queries and their uses?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain an exception and its types?
Explain the use of ignore option in imp command.
What are oracle functions?
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.
How to add a new column to an existing table in oracle?
What are the uses of linked server and explain it in detail?
