Oracle SQL - Store Setting to a file

  1. HOME
  2. Oracle SQL
  3. SQL Plus
  4. Script

Introduction

To save all your current SQL*Plus settings in a SQL*Plus script file, use the STORE SET command.

The syntax of this command. 

SQL> STORE SET <filename>[.sql] [REPLACE|APPEND]

The brackets [] means optional command clauses.

If you saved SQL*Plus settings in a script file by using the STORE SET command, you can restore those settings using the START (or @) command.

Related Topic