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 is a schema in oracle?

1014

How do I uninstall oracle 11g?

1119

how can we store any pdf file in oracle

2164

How to estimate disk space needed for an export job?

1051

Why is oracle database so popular?

1001

How to define an explicit cursor in oracle?

1040

What is an oracle table?

988

How to unlock the sample user account in oracle?

1018

How to create a table interactively?

1093

What is meant by recursive hints in oracle?

1089

What is a tns file?

997

What is the data pump import utility?

1035

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How to recover a dropped table in oracle?

1048

What are the different types of record groups in oracle? Explain each of them

1025