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

What is flashback in Oracle?

1014

Can objects of the same schema reside in different tablespace?

1059

How to retrieve values from data fields in record variables?

1105

Explain oracle 12c new features for developers?

1047

Explain coalesce function?

1196

How to view the data files in the current database?

1094

What are the uses of a database trigger?

989

How to create an oracle database manually?

1072

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

What is a cursor variable?

1115

Will you be able to store pictures in the database?explain.

990

Explain rename?

971

What is a data dictionary and how can it be created?

1137

How to use values from other tables in update statements using oracle?

1075

How to assign values to variables?

1090