Displays the default mode for hold cursors. For example:

    SQL> SHOW HOLD CURSORS MODE
    Hold Cursors default: WITH HOLD PRESERVE NONE