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
What is nvarchar in sql?
how to convert character strings to numeric values? : Sql dba
when MSQL8.0 is in market
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are different types of tables in sql?
What are different functions in sql?
Write a sql query to convert all character to uppercase after hypen.
What is memory optimized table?
Can you selectively load only those records that you need? : aql loader
What is the life of an sql statement?
What is an escape character in sql?
What is data type in sql?
What is sql indexing?
What is the use of <> sql?
How do I find duplicates in a single column in sql?