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
What packages(if any) has oracle provided for use by developers?
What are %type and %rowtype for?
What is difference between joins and union?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How to select random rows from a table?
How do you truncate?
How do you write a complex sql query?
Which version of sql do I have?
Why sql query is slow?
Define union, minus, union all, intersect ?
How do you rename a table in sql?
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.
What is a full join?
What does rownum mean in sql?
What is primary and foreign key?