Answer / shwetha k

A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

What is sql key?

0 Answers  

---

What are instead of triggers?

0 Answers  

---

What plvcmt and plvrb does in pl/sql?

0 Answers  

---

How are sql commands classified?

0 Answers  

---

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 a database and a relational database?

0 Answers  

---

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

Is foreign key mandatory?

0 Answers  

---