What is drawback of cursor?

What is drawback of cursor?

• Implicit cursors are less efficient than explicit cursors
• Implicit cursors are more vulnerable to data errors
• Implicit cursors provide less programmatic control

Similar Threads:

• What is a cursor? What are its types?
• Describe ref cursor in Oracle.
• Describe ref cursor in Oracle.
• Explain the attributes of implicit cursor.
• What Is Parallel Cursor Concept

What is Data Block?

• Data blocks are also called logical blocks, Oracle blocks, or pages.
• At the finest level of granularity, Oracle stores data in data blocks.
• A data block corresponds to a specific number of bytes of physical database space on disk.

What are the uses of Rollback Segment?

• Rollback segments undo changes when a transaction is rolled back
• They also ensure that transactions leave the uncommitted changes unnoticed.
• They can be used to recover the database to a consistent state in case of failures.