What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Answer / nishi
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
Is This Answer Correct ? | 1 Yes | 0 No |
How to create a table interactively?
Explain oracle instance.
How to manage transaction isolation level?
What is a parameter file in oracle?
How to bring a tablespace online?
What is an oracle tablespace?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
How do I manually uninstall oracle client?
what is pragma?
what is the syntax of SELECT command?
How to define an oracle sub procedure?
what is a view?