main difference between join and subqurey is that join is used for known

Whatz the main diff between Subquery and a Join

Question Posted / adil khan

Answer Posted / adil khan

main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What happens if you lost a data file?

991

How view is different from a table?

980

What is tns entry?

1073

What is Virtual Private Database in Oracle?

1030

How to retrieve values from data fields in record variables?

1051

How to install oracle database 10g xe?

974

Explain an integrity constrains?

1093

Respected sir, Please send me technical questions related to oracle apps..

1771

What is recovery manager(rman) backup in Oracle?

1141

How to use regular expression in pattern match conditions in oracle?

982

How to view all columns in an existing table?

887

Can we protect our pl/sql source code?

1003

Can we create database in oracle using command line ?

1039

How data locks are respected in oracle?

1023

What is set operator oracle?

936