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: create cursor c1(cursor name) as 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

What are the commands used in sql?

1133

---

What are the basic techniques of indexing?

1112

---

Can we join 3 tables in sql?

1108

---

What are pl sql procedures?

1080

---

Is pl sql different from sql?

1043

---

Explain normalization and what are the advantages of it?

1000

---

What is the difference between sql and t sql?

1107

---

What are dml commands?

1073

---

How do I access sql anywhere database?

1022

---

Explain autonomous transaction.

1220

---

Mention what is the use of function "module procedure" in pl/sql?

1088

---

What is the difference between mdf and ndf files?

1160

---

How do I find duplicates in the same column?

1170

---

Why we use triggers in mysql?

1038

---

What is partition by in sql?

1127

---