1)With commas (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 / tulsi

2 Answers
8114 Views
I also Faced
E-Mail Answers

Answer Posted / tulsi

1)With commas (SET price = 0, status = 'I')

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle pl sql developer?

963

What is identity column in sql server?

1034

Why do we use view in sql?

932

What is mutating error in pl sql?

1001

What port does sql server use?

1042

when is the use of update_statistics command? : Sql dba

1026

What is the best sql course?

970

What is sql rowcount?

987

what is the difference between join and union? : Sql dba

1089

What is the use of procedures?

963

Can we enter data in a table in design view?

951

What are the different types of functions in sql?

1035

What is a primary key called that is made up of more than one field?

1330

What is sql comments?

1059

How can I change database name in sql?

1050