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

What is the most common sql injection tool?

739

Write a sql query to convert all character to uppercase after hypen.

1171

What is difference between function and trigger?

719

How can you load multi line records? : aql loader

804

what are the differences among rownum, rank and dense_rank? : Sql dba

744

Is coalesce faster than isnull?

703

Can there be more than one function with a similar name in a pl/sql block?

750

What does count (*) mean?

684

Can we change the table name in sql?

707

What is clustered index sql?

700

What are different categories of sql commands?

808

What is the starting oracle error number?

762

What is latest version of sql?

713

What are different clauses used in sql?

813

What is the usage of when clause in trigger?

759