Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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 at 3:33

Your Answer

 
discard

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.