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
- 7567 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopa
with double-pipes (SET price=0 || status = 'I')
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is scope and visibility in PL/SQL?
What is case function?
What is the best free sql database?
What is pivot query?
What does sign mean sql?
What is the difference between having and a where in sql?
what is datawarehouse? : Sql dba
What is dml statement?
Mention what is the use of function "module procedure" in pl/sql?
what is transaction? : Sql dba
What is pl sql and why it is used for?
Is it possible to update views?
What is difference between joins and union?
What is sorting in sql?
what is a composite key ? : Sql dba
