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  

---

does sql support programming? : Sql dba

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

Explain the update statement in sql

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

---

Is oracle sql free?

0 Answers  

---

What is mutating error in pl sql?

0 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

---

What is the purpose of the sql select top clause?

0 Answers  

---