a sub query is a query nested within another query while join select rows

Whatz the main diff between Subquery and a Join

Question Posted / gomolemo kasale

Answer Posted / gomolemo kasale

a sub query is a query nested within another query while
join select rows from multiple table

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How a tablespace is related to data files?

1108

What is the difference between substr & instr functions?

1225

What are the parameters that we can pass through a stored procedure?

1064

How to get execution statistics reports on query statements?

1090

How to rename a tablespace in oracle?

1085

What is query image?

981

What are the differences between char and varchar2 in oracle?

1170

What is the implicit cursor in oracle?

1105

How to write numeric literals in oracle?

1182

How to assign a tablespace to a users in oracle?

1048

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2395

how to make an oracle object

2357

What is a trigger and what are its types?

1226

How to convert dates to characters in oracle?

1040

What is the oracle implicit cursor?

1061