Answer / b.v.srinivas

Ref cursor is a cursor variable which acts as a pointer to
the sql memory area.
Ref cursor can be asssociated with multiple sql statements
where as a cursor can be associated with only one sql
statement.
Refcursor is dynamic where as cursor is static.
Ref cursors are of two types:
1)strong ref cursor:which retuns value.
2)week ref cursor:which doesn't return value.


thanks and regards
B.V.Srinivas.

Answer / shailendra chauhan

For the strong ref cursor the returning columns with
datatype and length need to be known at compile time.

For the weak ref cursor the structure does not need to be
known at compile time.

TYPE WEAK_REF_CURSOR IS REF CURSOR;

TYPE STRONG-_ REF_CURSOR IS REF CURSOR RETURN
TABLE_NAME%ROWTYPE;

Answer / nagapawan

i have doubt ref cursor comes in pl/sql r not. pls clarify
any one

Answer / sure

ref cursor is a datatype we can assign variables that data type called cursor variable,cursor variable can associate with different queries at run time,primary advantage of refcursor is we can pass result set morethan one sub program

Answer / ramadoss r

REF CURSOR is a pointer in the oracle database.It is used
when the problem statement has more than one query.It comes
on PL/SQL only.Because in SQL we can't get answers for two
query at a time.

Answer / alladi venkateswarlu

Weak ref cursor types can be associated with any query
whereas strong ref cursor types can only be associated with
cursors of the same type.

Can you alter start with clause?

1 Answers   TCS,

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

How packaged procedures and functions are called from the following?

2 Answers  

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

What is cross join sql?

0 Answers  

Is ms sql traffic encrypted?

0 Answers  

what are ddl statements in mysql? : Sql dba

0 Answers  

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

How to call the function and Procedure in trigger?

3 Answers   IBM,