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 / vishu
3. The ROWS AFFECTED clause
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Does db2 use sql?
What is row_number () in sql?
Which join is default?
Is primary key a clustered index?
Where is pl sql used?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is sql injection owasp?
Mention what is the plv (pl/vision) package offers?
How many sql commands are there?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is pl/sql table? Why is it used?
What kind of join is join?
What are the types of subqueries?