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 to Execute a Package in PL/SQL.?

1185

---

How to use sql statements in pl/sql?

1100

---

What is pl sql in oracle?

1024

---

What is difference between pl and sql?

1035

---

Can a foreign key be null?

1069

---

How many triggers can be applied to a table?

1039

---

What is the difference between a primary key and a clustered index?

969

---

what is a constraint? Tell me about its various levels. : Sql dba

970

---

what is online transaction processing (oltp)? : Sql dba

979

---

What is the advantage of nosql?

1043

---

Does a user_objects view have an entry for a trigger?

1000

---

What is the difference between truncate and drop statements?

1165

---

Can ddl statements be used in pl/sql?

1122

---

explain what is mysql? : Sql dba

1065

---

What are the parts of a sql statement?

1072

---