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 see the data (in unix) using dataset in datastage?
How to pass a cursor variable to a procedure?
What is an oracle tablespace?
various types of hints and their usage
How to create an oracle database?
What is a proxy object?
Difference between inner join vs where ?
Name the various constraints used in oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is clustered table in Oracle?