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 many scalar data types are supported in pl/sql?
What is a file delimiter?
What is sql exception?
What are the different types of dbms?
How do you write a subquery?
What is pivot in sql?
which operator is used in query for pattern matching? : Sql dba
Is sql a dbms?
What are sql constraints?
What is scalar data type in pl sql?
Why is theta join required?
What is cte sql?
How is indexing done in search engines?
What is a left inner join?
Does pl sql work in mysql?