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

How is use pl and sql?

1000

---

What are the most important ddl statements in sql?

1024

---

how to decrement dates by 1 in mysql? : Sql dba

967

---

What is the use of desc in sql?

913

---

Can we alter stored procedure?

939

---

What are all the different normalizations?

968

---

What are the different types of dbmss?

962

---

What does cursor do in sql?

969

---

What is mutating trigger?

966

---

how to check server status with 'mysqladmin'? : Sql dba

1009

---

What is rank dense_rank and partition in sql?

969

---

Can you sum a count in sql?

952

---

Is natural join same as inner join?

869

---

How do I write a cron which will run a sql query and mail the results to agroup?

910

---

How does sql*loader handles newline characters in a record? : aql loader

984

---