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
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how to use regular expression in pattern match conditions? : Sql dba
what are aggregate and scalar functions? : Sql dba
what are all the common sql function? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
define sql insert statement ? : Sql dba
What is the current version of postgresql?
Can we use distinct and group by together?
Is inner join faster than left join?
Can we rollback truncate?
Is primary key clustered index?
what are the advantages of sql ? : Sql dba
Can delete statement be rollbacked?
What is the current version of sql?
how to start mysql server? : Sql dba
