Ref cursor comes in PL/SQL. You can return a ref cursor in a function. A

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

Question Posted / raghu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How does sql developer connect to oracle database?

1001

difference between anonymous blocks and sub-programs.

1133

How do I view output in sql developer?

1084

Why stored procedure is better than query?

946

Is record in pl sql?

971

Is left join faster than join?

1053

Does oracle roll back the transaction on an error?

1013

How to assign sql query results to pl sql variables?

1078

How exception handling is done in advance pl/sql?

981

Where can I learn sql for free?

986

explain primary keys and auto increment fields in mysql : sql dba

977

What do you mean by stored procedures?

1012

What is the difference between row level and statement level trigger?

1021

what are different types of keys in sql?

1148

Can variables be used in sql statements?

1030