Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32992 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / siva
Sub Query:
The Sub Query only get the results as one table or the
other table based that the result be of onther table as
used in the table.
The two tables information are dispalyed as combiend.
Join:
To get results more rhan two tables information.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How to update a table row with a record?
How can Oracle users be audited?
What is meant by a deadlock situation?
What are the varoius components of physical database structure of oracle database?
Differentiate between pre-select and pre-query?
What are the advantages of oracle 12c?
Can multiple columns be used in group by in oracle?
if you ctreate table identity
what is the difference between substr and instr function in oracle?
How to select all columns of all rows from a table in oracle?
How does Oracle guarantee data integrity of data changes?
what is insert all statement in sql
What is a schema in oracle?
How to create a server parameter file?
How to create a testing table in oracle?
