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...

Which clause of an UPDATE statement allows you to affect
only certain rows of a table?

1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause

Answer Posted / chandrasekar.ramasamy

The where clause

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What packages(if any) has oracle provided for use by developers?

5813


What are %type and %rowtype for?

1057


What is difference between joins and union?

1133


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1076


How to select random rows from a table?

1081


How do you truncate?

915


How do you write a complex sql query?

1092


Which version of sql do I have?

1063


Why sql query is slow?

1005


Define union, minus, union all, intersect ?

1012


How do you rename a table in sql?

1120


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2087


What is a full join?

996


What does rownum mean in sql?

1034


What is primary and foreign key?

1068