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  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

What is trigger point?

0 Answers  

---

What is the best partition size for windows 10?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

How can you load multi line records? : aql loader

0 Answers  

---