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.

Show the cursor attributes of pl/sql.

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

How many sql are there?

0 Answers  

---

What are commit, rollback, and savepoint?

0 Answers  

---

What's the difference between inner join and left join?

0 Answers  

---

How do I run a sql query?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

How to sort the rows in sql.

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---