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
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how would you enter characters as hex numbers? : Sql dba
How is a process of pl/sql compiled?
Explain architecture of sql server notification services?
What is triggering circuit?
What do you understand by case manipulation functions?
What is sql prepared statement?
State few characteristics of pl/sql?
How do you explain an index?
What are pl/sql packages?
What are the various restrictions imposed on view in terms of dml?
What are the different types of constraints?
What are inner and outer joins examples of both?
How do I remove sql developer from windows 10?
What is use of package in pl sql?
What is full join?
