Answer Posted / s.syam sundar

oracle uses a private area to process and store data.this
private area is called as cursor

we have two types of cursors
they are implict and explict
implict cursor:- it is a cursor which controlled by oracle
itself
Ex: select statmets,insert,update and delete statmets

explict cursors:- it is a cursor which controlled by
programmer

controlling means
open cursor
fetch into
close cursor

Ex: cursor c1(cursor name) is select * from emp
where deptno =10;( this is in declarative section)


in excutable section:
open cursor c1;
fetch cursor c1 into some veriable or table name;
......
.....
close c1

we can use parameters in cursors

and we can not assiagn cursor name to a variable

and we need not use cursor statemets in for update cursor
because it will take care of

regards
S.syam sundar

How do I partition a table in sql?

1138

---

How to read xml file in oracle pl sql?

916

---

What do you understand by pl/sql packages?

1066

---

Is a view faster than a stored procedure?

975

---

What is user defined functions?

990

---

how do you tune the slow running queries in oracle db , explain the methodology

2823

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031

---

What are the parameter modes supported by pl/sql?

1114

---

Does google use sql?

969

---

What is the purpose of using pl/sql?

1150

---

how do you know if your mysql server is alive? : Sql dba

1081

---

Can we join 3 tables in sql?

1049

---

What is rename in sql?

979

---

how are mysql timestamps seen to a user? : Sql dba

1142

---

What are the 3 types of behavioral triggers?

1257

---