Forum Stats

  • 3,827,745 Users
  • 2,260,818 Discussions
  • 7,897,364 Comments

Discussions

SQLPLUS COLUMN POSITION

Dear All

I would like to print out the column per position in my spool file

Like I need to get the username in position(5) not (6)

set trimspool on

SET TRIMSPOOL ON

SET TRIMOUT ON

set echo off

set heading off

set feedback off

set verify off

col INS a4

col USERNAME format a20

col USER_ID format a10

set COL USERNAME RIGHT

spool on

Select '0001' as INS,USERNAME from dba_users;

spool off

Tagged:

Answers