What are various joins used while writing SUBQUERIES?

Answer Posted / basanti

Joins and subquery both are different.
We don't use joins while writing subqueries.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the order of defining local variables and sub procedures/functions?

593


What is Library Cache in Oracle?

635


What is a named program unit?

576


What is oracle join syntax?

562


How to load data through external tables?

576






Which is better Oracle or MS SQL? Why?

3956


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1844


Give the different types of rollback segments.

569


How to get maxsal , minsal, ename department wise in single query

1007


How to use fetch statement in a loop?

547


What is a package in oracle?

560


material view and view disadvantages?

631


How to get a list of all background sessions in the database?

531


How to create an oracle testing table?

584


what is Single Byte Overhead...?

2055