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

How to define an oracle cursor variable?

1088

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2406

What is catalog in Oracle?

1431

How to create a new table by selecting rows from another table?

1145

Can you create a synonym without having a table?

1089

Why does oracle 9i treat an empty string as null?

1124

Describe an oracle table?

1093

What is hot backup and logical backup?

1111

How to use "for" statements in oracle?

1118

What is sequence?

1136

What privilege is needed for a user to connect to oracle server?

1031

Why should I use oracle database?

1042

Explain the use of indexes option in exp command.

1205

How to view the tablespaces in the current database?

1022

Is java required for oracle client?

1043