What is a REF CURSOR? Compare strong and week ref cursor types.

Answers were Sorted based on User's Feedback



What is a REF CURSOR? Compare strong and week ref cursor types...

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.

Is This Answer Correct ?    32 Yes 5 No

What is a REF CURSOR? Compare strong and week ref cursor types...

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;

Is This Answer Correct ?    21 Yes 5 No

What is a REF CURSOR? Compare strong and week ref cursor types...

Answer / nagapawan

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

Is This Answer Correct ?    10 Yes 2 No

What is a REF CURSOR? Compare strong and week ref cursor types...

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

Is This Answer Correct ?    8 Yes 0 No

What is a REF CURSOR? Compare strong and week ref cursor types...

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.

Is This Answer Correct ?    5 Yes 3 No

What is a REF CURSOR? Compare strong and week ref cursor types...

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.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is an alias command?

0 Answers  


What is function and procedure?

0 Answers  


Write a query to find the names of users that begin with "um" in sql?

0 Answers  


How to run pl sql program in mysql?

0 Answers  


How do you change a value in sql?

0 Answers  






What is the difference between sql and t sql?

0 Answers  


Name the different types of indexes in sql and define them.

0 Answers  


What is the difference between nested table and varray?

0 Answers  


Does sql profiler affect performance?

0 Answers  


Does sql view stored data?

0 Answers  


In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  


what is a field in a database ? : Sql dba

0 Answers  


Categories