Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLPLUS COLUMN POSITION

Ibrahim AlzaidiOct 10 2021

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

Comments

Post Details

Added on Oct 10 2021
1 comment
74 views