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
- 6 Answers
- 13017 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)THE WHERE CLAUSE
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Is primary key a clustered index?
Do we need to rebuild index after truncate?
What is sql character function?
What is rownum and rowid?
What are the types of triggers in sql?
What is a field in a database?
What is sql engine in oracle?
What is a clob in sql?
Is nosql relational?
Why plvtab is considered as the easiest way to access the pl/sql table?
Define SQL and state the differences between SQL and other conventional programming Languages?
Why do we use procedures in sql?
What are sql*plus environment variables?
What is the main difference between sql and pl/sql?
What are the different types of joins in sql?
