Interested to Buy Any Domain ? << Click Here >> for more details...
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
- 1 Answers
- 2668 Views
- I also Faced
- E-Mail Answers
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 |
What is Hash Cluster ?
How remove data files before opening a database?
Give the constructs of a package, function or a procedure.
What are the basic element of Base configuration of an oracle Database ?
What are the differences between blob and clob in oracle?
What is a Segment ?
Describe varray?
Where do we use decode and case statements?
How can we view last record added to a table?
how to genarate random numbers in oracle for particular row?
How to drop an existing table in oracle?
What is the database name in oracle?
Oracle General 
