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

Explain ddl statements in pl/sql?

958

What are the two virtual tables available at the time of database trigger execution?

1156

discuss about myisam key cache. : Sql dba

974

what is single byte over head in oracle..?

2339

What is an example of translating a date into julian format?

1038

What is an exception in pl/sql?

1005

What is a primary key example?

901

What is sql key?

917

What is %type in pl sql?

924

How do I install microsoft sql?

981

What is a null value?

1084

Is it possible to pass parameters to triggers?

1030

How to execute a stored procedure?

1030

Which is faster union or join?

901

What is rename in sql?

915