SQLPLUS COLUMN POSITION

Ibrahim Alzaidi · Oct 10, 2021 4:12PM

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

EdStevens · Oct 10, 2021 6:06PM

There is nothing gained by posting the same question in multiple spaces.

Forum Stats