Answer / kumar srinivasalu

Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time

Answer / somashekhar m

By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.

in ACID cursor works for consistency of the data.

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

Why procedure is used in sql?

0 Answers  

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

Difference between SUBSTR and INSTR?

3 Answers  

---

how to convert numeric values to character strings? : Sql dba

0 Answers  

---

What are the uses of merge?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

What are database links used for?

0 Answers  

---

What is rtm in testing?

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

What is range partitioning?

0 Answers  

---