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
8150 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

Why is pl sql needed?

953

What is a null value?

1150

What is %rowtype in pl sql?

994

What is cascade in sql?

966

how to create a new view in mysql? : Sql dba

941

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1160

How do I remove sql developer from windows 10?

1116

What is an index in sql with example?

977

Can we use pl sql in mysql?

1016

What are secondary keys?

972

Can a table have no primary key?

1066

What do you think about pl/sql?

1040

What is bulk compiling in pl/sql.?

1136

Why commit is not used in triggers?

1043

what are string data types? : Sql dba

1047