Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?

Answers were Sorted based on User's Feedback



i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / sureshkumar somayajula

Hi ,

It will use in PL/SQL. Reusability of Cursor is nothing
but "REF CURSOR".These are of 2 types.

1. Weak Ref cursor 2. Strong ref Cursor.

Is This Answer Correct ?    9 Yes 0 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / raghu

Ref cursor comes in PL/SQL.
You can return a ref cursor in a function.
A ref cursor is useful while returning more values.

Is This Answer Correct ?    8 Yes 1 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / murali

ref cursor is of pl/sql topic

the main use of Ref Cursor is we can create multiple activeset area using refcursors

Is This Answer Correct ?    1 Yes 0 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / nirma durra

Ref-Cursor is DataType

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

what are the forced views

6 Answers   Hexaware, TCS,


How can check sql version from command line?

0 Answers  


How can you tell the difference between an index and a view?

0 Answers  


Explain 3 basic parts of a trigger.

0 Answers  


What is the maximum number of columns in sql table?

0 Answers  






What is synonyms?

0 Answers  


How to know the last executed procedure?

0 Answers  


If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  


What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,


What is an ndf file?

0 Answers  


What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  


Which nosql database is best?

0 Answers  






Categories