Oracle SQL - SQL*Plus System Variables

  1. HOME
  2. Oracle SQL
  3. SQL Plus
  4. Define System Variable

Introduction

SQL*Plus system variables control the overall behavior of SQL*Plus.

For system variables, you need the SQL*Plus commands SET and SHOW to assign or retrieve values, respectively.

The following code demonstrates some examples of system variables. 

SQL> show pagesize
pagesize 36

SQL> show pause
PAUSE is OFF

SQL> set  pause '[Enter]... '
SQL> set  pause  on
SQL> set  pagesize 10

SQL> select * from emp;
[Enter]...

SQL> set  pause off pagesize 42
SQL> show all
...
SQL>

SHOW ALL display all SQL*Plus System Variables.

Related Topic