Forum Stats

  • 3,838,585 Users
  • 2,262,383 Discussions
  • 7,900,690 Comments

Discussions

SQLPLUS COLUMN POSITION

Ibrahim Alzaidi
Ibrahim Alzaidi Member Posts: 6 Blue Ribbon

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