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
8238 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 is difference between stored procedure and trigger?

1246

What is a call statement? Explain with an example.

1068

How many times can we commit in a loop?

1065

How is sql used in oracle?

1037

Enlist the data types that can be used in pl/sql?

1106

Can a varchar be a primary key?

1045

what are different types of keys in sql?

1215

what is a relationship and what are they? : Sql dba

1162

What port does sql server use?

1110

Can we use commit inside a trigger?

1144

what is the difference between group by and order by in sql? : Sql dba

1183

What is sql performance tuning?

978

What is minus?

1050

Which normal form is best?

996

what is a trigger in mysql? Define different types of trigger. : Sql dba

1112