sub query: it is a query to get the answer for multiple questions joi

Difference between join and a subquery?

Question Posted / rajasekhar

Answer Posted / rajasekhar

sub query: it is a query to get the answer for multiple questions

joins: it is used for getting the data from more then two tables

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a database schema in oracle?

1101

Explain database link?

1102

Briefly explain what is literal? Give an example where it can be used?

1022

What is a nvl function?

1013

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

965

What happens in oracle commit?

1017

How to end the current transaction in oracle?

1020

What is save point in oracle database?

1289

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2227

What is connection pooling in oracle?

962

Why is oracle used?

932

How to check database size in Oracle?

1181

What is control file used for?

1193

What is oracle server autotrace in oracle?

1157

Explain index?

1250