Difference between join and a subquery?

Answer Posted / maddy

Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....

join is used to join the two table is used to retriew the
data from 1 or more tables.....

Is This Answer Correct ?    27 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different editions of oracle?

593


What is a nested table?

633


What is ordinary table in oracle?

653


What are the tools for Oracle ?

612


How to call a stored function with parameters?

564






Which is faster join or subquery in oracle?

537


What is a snapshot in oracle database?

583


definition of cluster and non-clustered index?

2479


Explain the use of rows option in imp command.

604


Is truncate autocommit in oracle?

641


How do I know if oracle is installed on windows?

488


What are dml statements in oracle?

623


Explain the use of consistent option in exp command.

554


How to open a cursor variable?

611


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1695