with double-pipes (SET price=0 || status = 'I')

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')

Question Posted / roopa

2 Answers
8115 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

Please Help Members By Posting Answers For Below Questions

what are the differences between char and nchar? : Sql dba

1096

What is the use of & in pl sql?

1030

What are tables and fields?

1013

What is a temporal data type?

1026

How to use sql statements in pl/sql?

1098

What is pl sql and why it is used for?

1098

How much does sql certification cost?

1065

What is dynamic query?

957

What is %s in sql?

996

What are the benefits of stored procedures?

1046

What is audit logout in sql profiler?

1005

What pl/sql package consists of?

1059

Is sqlexception checked or unchecked?

949

what is sub-query? : Transact sql

1081

Is sql similar to python?

959