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.

What is recursive join in sql?

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

what are all types of user defined functions? : Sql dba

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

Explain alias in sql?

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---