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
Last activity: Jun 7, 2025, 09:01 AM