Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In SQL*Plus, is there a way to save current COLUMN settings similar to STORE which saves SET commands in a script?

COLUMN can be used to list the settings, but they are not in script format.

share|improve this question

You can edit $ORACLE_HOME/sqlplus/admin/glogin.sql file and add inside your col format settings :)

[ora11g@botor ~]$ cat /u01/app/ora11g/product/11.2.0/db_1/sqlplus/admin/glogin.sql
define _editor=vi
set lines 450
set pages 100
set time on
set timi on
set serveroutput on
share|improve this answer
Yeah, i'm using login.sql for that. However, i am looking for the current COLUMN settings, which may be changed for an ad hoc report. – please delete me Jun 22 '14 at 3:33

You can spool the output from running the 'column' command to a file. This will give you the basis of a script but you will need to ensure that each column stsement is on a single line, e.g.

       COLUMN   value_col_plus_show_param ON
       FORMAT   a30


       COLUMN   value_col_plus_show_param ON HEADING  'VALUE' FORMAT   a30

You could either automate the removing of the carriage returns using sed or do it manually with your preferred editor.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.