What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Answer Posted / 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 |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
How to assign values to data fields in record variables?
Can multiple columns be used in group by in oracle?
Can the query output be sorted by multiple columns in oracle?
What is meant by an index?
Differentiate between function and procedure in oracle.
How remove data files before opening a database?
What is Segment Advisor in Oracle?
How can we force the database to use the user specified rollback segment?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
how to handle exceptions in post production
What is oracle data type?
What is an oracle wallet?
Explain an exception and its types?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??