Answer Posted / shaveta gulati
Ref Cursor:
ref cursor is a data structure which points to an object
which in turn points to the memory location.
ex:
create or replace procedure test()
as
begin
type ref_cursor is ref cursor;
open ref_cursor as
select * from table_name;
end;
There are 2 types in this.
1.strong ref cursor:
This has a return type defined.
2. weak ref cursor.
this doesnt have a return type
normal cursor:
Nothing but the named memory location.
it has 2 types
1. explicit cursor
Need to be defined whenever required.
2.Implicit cursor
need not defined and used by oracle implicitly in DML
operation.
In case of an normal explict cursor, the SQL query has to
be defined at the time of declaring the cursor itself. In
case of REF Cursor, the cursor declartion is not associated
with any SQL query, it is associated with a query at a
later stage this brings in a lot of flexibility as
different SQL queries can be associated with the cursor
(one at a time, offcourse) programatically. REF Cursors
also provide the feature of passing parameters. Though
there is something dynamic with REF Cursor when compared to
a normal explicit cursor, it is not a truly perfect dynamic
cursor. Truly perfect dynamic cursors are the one
constructed using DBMS_SQL package.
| Is This Answer Correct ? | 42 Yes | 7 No |
Post New Answer View All Answers
What do you understand by concurrent programs?
testing tools?
In oracle application how do you debug or trace errors?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What are the different components of soa suite?
Tell me how to debug the report?
What do you understand by soa and what are the benefits of using this architecture?
what are the balancing segments in AR?
Can we create tables in apps schema?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Is soa a part of oracle fusion middleware?
can we get profile values in report without using user exists is it possible how?
How can a process be deployed in soa?
In hierarchical structure of a database? we have write query from where we should start?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
