Whatz the main diff between Subquery and a Join
Answer Posted / kuldeep singh
Join:
It is the machanism of joining one or more tables together
and finding information from one or all tables used in join.
Sub Query:
It is a method of finding answer using another query as
parametere for first query.
Main Difference:
In join both the tables should have a comman column type
but in subquery without having a column type we can execute
the query.
Is This Answer Correct ? | 17 Yes | 16 No |
Post New Answer View All Answers
how the indexes are stored in the Oracle Database?
Explain an exception?
Explain parameter file in oracle.
What is a view and how is it different from a table?
How to revoke create session privilege from a user in oracle?
What is where clause in oracle?
Use of an integrity constraint is better to validate data. Explain
Explain the truncate in oracle?
What are group functions in oracle?
How to view the data files in the current database?
What is analyze command used for?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is snapshot is too old? Give and example for better understand.
How to grant create session privilege to a user in oracle?
What is connection pool in oracle?