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

What is trigger types in sql?

1042

---

what is timestamp in mysql? : Sql dba

1130

---

How do you sort in sql?

1067

---

What are stored procedures in mysql?

1070

---

What is union and union all keyword in sql and what are their differences?

1157

---

What will you get by the cursor attribute sql%notfound?

1128

---

how to get @@error and @@rowcount at the same time? : Sql dba

1076

---

Cite the differences between execution of triggers and stored procedures?

1136

---

What is the difference between alter trigger and drop trigger statements?

1162

---

explain the difference between myisam static and myisam dynamic. : Sql dba

988

---

What is execution plan in sql?

1089

---

Is inner join faster than left join?

1249

---

What is the difference between syntax error and runtime error?

1179

---

What does dml mean?

1041

---

what is a foreign key ? : Sql dba

1113

---