Explain reference cursor?
- 1 Answers
- 2263 Views
- I also Faced
- E-Mail Answers
Answer / Bhasker Sah
A Reference Cursor is a type of cursor in Oracle PL/SQL programming language. Unlike a regular cursor, which stores the result set within the program's memory, a Reference Cursor returns a result set as a separate object that can be used elsewhere in the program or passed as an argument to another procedure or function. It provides better performance and flexibility for handling complex data sets.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to limit the max no of rows retrieved in the report?
What is scd1 , scd2 , scd3?
How Materialized Views are linked with Oracle DataWare house?
What is IQD file?
Difference between DSS & OLTP?
Explain the definition of normalized and denormalized view?
What are the steps involved in creating dimensional modeling process?
What is the difference between snowflake and star schema?
What is Active Datawarehousing?
What are the different types of Fatcs? Explain with example only
What are algorithms provided by Microsoft in SQL Server?
What are situations where snowflake schema is better than star schema when the opposite is true?
Teradata 
