Oracle SQL - Display current SQL*Plus settings

Introduction

You can display the current SQL*Plus settings with the SHOW command.

SQL> show pages
pagesize 22

SQL> show pause
PAUSE is ON and set to "Hit [Enter]... "

Related Topic