Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8019 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
What is basic structure of pl sql?
Is nosql faster than sql?
Where not exists in sql?
What is the difference between functions, procedures, and packages in pl/sql?
How to write a query to show the details of a student from students table whose
Does a join table need a primary key?
What sql does db2 use?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is package in pl sql?
What are the most important characteristics of pl/sql?
What does the acronym acid stand for in database management?
what is a record in a database ? : Sql dba
What are the differences between in and exists clause?
How does stored procedure reduce network traffic?
Are sql connections encrypted?
