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
- 2664 Views
- I also Faced
- E-Mail Answers
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 to use attributes of the implicit cursor in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is an external table?
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?
Can a formula column be obtained through a select statement ?
What is oracle update statement with inner join ?
How to create a new user account in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is catalog in Oracle?
What is a select query statement in oracle?
Explain table?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
what is port in oracle? how is it related to database application.
What is the use of oracle?
What is clustered table in Oracle?
