Whatz the main diff between Subquery and a Join
- 14 Answers
- 31194 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suramya biswas
Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of tables supported by oracle?
How to get maxsal , minsal, ename department wise in single query
What is procedure overloading in oracle?
Explain self joins in oracle?
Can we create trigger on materialized view in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Why is oracle used?
How to sort the query output in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a dead lock in oracle?
What is a select query statement in oracle?
How to convert characters to dates in oracle?
Can multiple columns be used in group by in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
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.
