How are multiple column = value pairs delimited in the SET
clause of an UPDATE statement?
1. With commas (SET price = 0, status = 'I')
2. With parentheses (SET (price = 0) (status = 'I'))
3. With double-pipes (SET price = 0 || status = 'I')
4. With square-brackets (SET [price = 0] [status = 'I']
5. With single or multiple spaces (SET price = 0 status
= 'I')
- 2 Answers
- 7138 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)With commas (SET price = 0, status = 'I')
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
When is the update_statistics command used?
Which command is used to delete a package?
What is difference between cursor and trigger?
What is synonyms?
Explain what is dbms?
Write a sql query to get the third highest salary of an employee from employee_table?
Explain the components of sql?
What is a mutating table and a constraining table?
What is the basic form of sql query?
Why do we need cursor in pl sql?
Define sql delete statement.
How can triggers be used for the table auditing?
What are the types of operators available in sql?
Show the cursor attributes of pl/sql.
how to use in conditions? : Sql dba
