We can return one more than one value by using reference cursors.

How to return more than one value from a function?

Question Posted / swapna

Answer Posted / swapna

We can return one more than one value by using reference
cursors.

Is This Answer Correct ?

26 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Why schema is used in sql?

1084

Name three sql operations that perform a sort.

1057

What is %type in sql?

1006

What is the use of index in hive?

1050

What is int identity in sql?

1201

What are the two parts of design view?

1060

What are pl/sql packages?

1151

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1044

what is “go” in t-sql? : Transact sql

1153

How to run sql commands in sql*plus?

1247

Can we use join in subquery?

1142

How do you use collections in procedure to return the resultset?

2279

Do we need to create index on primary key?

963

How can we optimize a sql query?

1105

what is the difference between a having clause and a where clause? : Sql dba

1154