Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Whatz the main diff between Subquery and a Join

Answer Posted / suramya biswas

Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the limitations of check constraint?

1022


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2450


Describe varray?

1052


What are a collation and state the different types of collation sensitivity?

1162


How to find the duplicate rows count from employees table in oracle?

1078


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

2318


What is a cursor in oracle?

1168


How to select some rows from a table in oracle?

1071


How to create tables for odbc connection testing?

1102


How to pass parameters to procedures?

1026


What is materialized view in Oracle?

1066


Explain temporal data types in oracle

1088


How can we create the complete backup of data in the oracle.

2149


What are the differences between lov and list item?

1058


Explain the use of constraints option in exp command.

1039