Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
Submitted by: AdministratorThe 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
Submitted by: Administrator
RETURN students%ROWTYPE
Submitted by: Administrator
Read Online Oracle SQL Job Interview Questions And Answers
Top Oracle SQL Questions
☺ | Explain Difference between an implicit and an explicit cursor? |
☺ | Explain What is difference between SUBSTR and INSTR? |
☺ | Explain What are various joins used while writing SUBQUERIES? |
☺ | Explain Difference between procedure and function.? |
☺ | Explain What is an UTL_FILE.What are different procedures and functions associated with it? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |