Whatz the main diff between Subquery and a Join
- 14 Answers
- 29059 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / mythili
Join:
It is the method of joining one or more tables together and
finding a answer.
Sub Query:
It is a method of finding one answer using another query.
Main Difference:
In join both the tables should have a comman column name
but in subquery without having a column name we can execute
the query.
| Is This Answer Correct ? | 30 Yes | 19 No |
Post New Answer View All Answers
How to rollback the current transaction in oracle?
How to do clean up if create database failed?
What is private procedure oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is PL/SQL ?
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.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to select all columns of all rows from a table in oracle?
What is oracle rowcount?
What is the usage of synonyms?
how can we store any pdf file in oracle
How to convert character types to numeric types?
What is format trigger?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
