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
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you explain an index?
What is the difference between alter trigger and drop trigger statements?
what is heap table? : Sql dba
Define union, minus, union all, intersect ?
Is merge a dml statement?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Why indexing is needed?
Can you have a foreign key without a primary key?
How do I run a sql trace?
What do you mean by stored procedures? How do we use it?
What is the most restrictive isolation level? : Transact sql
Is and as keyword in pl sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is raid? How does it help storage of databases?
What does rownum mean in sql?