What is a REF CURSOR? Compare strong and week ref cursor types.
Answer Posted / shailendra chauhan
For the strong ref cursor the returning columns with
datatype and length need to be known at compile time.
For the weak ref cursor the structure does not need to be
known at compile time.
TYPE WEAK_REF_CURSOR IS REF CURSOR;
TYPE STRONG-_ REF_CURSOR IS REF CURSOR RETURN
TABLE_NAME%ROWTYPE;
Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
explain normalization concept? : Sql dba
Does sqlite need a server?
Can a table contain multiple foreign key’s?
What is over () in sql?
how many ways to get the current time? : Sql dba
How do I run a query in pl sql developer?
Can function return multiple values in sql?
how to extract a unit value from a date and time? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is benefit of creating memory optimized table?
What is delimiter in pl sql?
Whis is not false in primary key?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is index example?
Why use stored procedures?