What is REF Cursor?
Answers were Sorted based on User's Feedback
Answer / saleem
It is dynamic Cursor.
They are two types
1) Strong- Return type
2) weak- No Return type
Is This Answer Correct ? | 105 Yes | 8 No |
Answer / sankar
CURSOR IN WHICH QUERY CAN BE CHANGED AT RUNTIME IS CALLED
REF CURSOR.
Is This Answer Correct ? | 87 Yes | 14 No |
Answer / kapil gangrade
ref cusor is a dynamic type of cursor which is used to
provide Reusability of cursor.......
Is This Answer Correct ? | 67 Yes | 8 No |
Answer / shukla
Ref Cursor is a PL/SQL Datatype. This is used to store
result of a query. Ref cursor is used in situations when
you want to encapsulate logic within sub-program i.e. your
query is changing depending on certain criterian. This
reduces the complexity of our program if we were to
implement same logic in a single query for getting the
desired output.
Is This Answer Correct ? | 59 Yes | 13 No |
Answer / 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 |
Answer / a.v.bhaskar reddy
REF CURSOR is majorly used when we want to execute a
dynamic select statement causes to retrieve more than one
record. We can pass Ref cursor result as a out parameter
which can be used in other subprograms
Is This Answer Correct ? | 28 Yes | 4 No |
Answer / manish sharma
a refrence cursor is data type like record type etc,we can
call it dynamiclly ,its an cursor so that it is binding of
more querry.so that if we need more querry output at run
time we can use it,in a normal cursour must have a
declarative part but in a ref cursor,we can call the cursor
without declration of cursor.
Is This Answer Correct ? | 16 Yes | 2 No |
Answer / a.v.bhaskar reddy
Ref cursor are the pointor to the server side cursor
variables they can be attached to diff statments and can
store diff value during runtime.i mean they act basically
dynamiclly we call them as true PLSQL variable
Is This Answer Correct ? | 16 Yes | 4 No |
Answer / niranjan kumar
Ref Cursor is also known as dynamic cursor,it is a data
type to solve situation which demand run time where
condition.Without creating instance we cannot use refcursor.
Is This Answer Correct ? | 6 Yes | 0 No |
how many sections are there in report?
What is an Index , Types od index why we are use index.
what are centralized and decentralized level of control of item attributes?
What are the files you have used in the part of Conversion and Interfaces?
whats the use of after parameter form and before report?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
what is meant by Drill Down in Discoverer report? why it will be use?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
How to register a form and stored procedure in oracle apps
What is oracle soa suite?