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')
- 2 Answers
- 7161 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)With commas (SET price = 0, status = 'I')
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Does group by remove duplicates?
What is the command used to fetch first 5 characters of the string?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Write a query to display the current date in sql?
How can the performance of a trigger be improved?
How do you optimize a stored procedure in sql?
What is a system versioned table?
What is thread join () in threading?
How does a trigger work?
How can we find duplicate records in a table?
What is the command used to fetch the first 5 characters of a string?
How run sql*plus commands that are stored in a local file?
What are the advantages of stored procedure?
What is the maximum number of triggers, you can apply on a single table?
What is clustered index in sql?
