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 you write an index?

1008

---

What does dml mean?

1045

---

How sql query is executed?

1189

---

How exception is different from error?

1068

---

explain mysql aggregate functions. : Sql dba

1032

---

Which type of cursor is used to execute the dml statement?

997

---

how mysql optimizes distinct? : Sql dba

1128

---

how many ways we can we find the current date using mysql? : Sql dba

1146

---

What is sql indexing?

1065

---

How to process query result in pl/sql?

1204

---

Explain the uses of a database trigger?

1091

---

Is full outer join same as cross join?

1019

---

What is left join example?

1009

---

what are local and global variables and their differences? : Sql dba

1141

---

What is an implicit commit?

1105

---