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 retrieve data from different tables ,place this data in different excel worksheets.
What is oracle open database communication (odbc)?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is an oracle user role?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to assign a tablespace to a users in oracle?
what is the difference between rollback & commit? can a foreign key has null value?
How to filter out duplications in the returning rows using oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What are the uses of linked server and explain it in detail?
How to define Data Block size ?