Sample Header Ad - 728x90

ignore column width in sqlplus

0 votes
2 answers
231 views
I'm getting the follow SQLPLUS> create table source(aa nvarchar2(2), bb nvarchar2(100), cc nvarchar2(10)); insert into source values ('aa',null,'aa'); insert into source values (null,'aa','aa'); insert into source values ('aa','aaa',null); set serveroutput on pages 0 feedback off echo off head off verify off numformat 99999999999.9999999999999 null '\N' colsep ' ' linesize 32767 select * from source; aa \N aa \N aa aa aa aaa \N I want to ignore the column width and show the result as ` without touching the SQL (only the commands before it or sqlplus`). So the result will look like: aa \N aa \N aa aa aa aaa \N (representing tab as two spaces)
Asked by Nir (529 rep)
Mar 13, 2023, 07:02 AM
Last activity: Jun 7, 2025, 09:01 AM