SQLPLUS COLUMN POSITION

Ibrahim Alzaidi

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

thatJeffSmith-Oracle

stop using sqlplus, stop worrying about all this COL settings, just use SQLcl, and run your query