Whatz the main diff between Subquery and a Join
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
Explain enable novalidate constraint.
What are the different types of synonyms?
How does the on-delete-cascade statement work?
How to convert characters to numbers in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
Will you be able to store pictures in the database?
How to put more than 1000 values into an oracle in clause?
Does oracle partitioning improve performance?
How a database is related to tablespaces?
What is oracle used for?
What do you mean by group by clause?
What is a subquery in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the use of Merge statement in oracle 11g