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  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

---

What is difference between left and right outer join?

0 Answers  

---

what is myisam? : Sql dba

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

Show how functions and procedures are called in a pl/sql block.

0 Answers  

---

What is trigger types of trigger?

0 Answers  

---

How do you rename a table in sql?

0 Answers  

---

what is 'mysqlcheck'? : Sql dba

0 Answers  

---