sql*plus column format remove whitespace

From: Alok Bisani <alok_bisani_at_yahoo.com>
Date: 28 Oct 2004 03:25:56 -0700
Message-ID: <f28905db.0410280225.23ca2f21_at_posting.google.com>



Hi,

[Quoted] [Quoted]     Is there a column format in SQL*PLUS to trim whitespace? For eg. the following query output
SQL> select owner, table_name, tablespace_name, cluster_name from all_tables where rownum < 2;

OWNER                          TABLE_NAME

------------------------------ ------------------------------
TABLESPACE_NAME CLUSTER_NAME
------------------------------ ------------------------------
SYS UNDO$

SYSTEM SQL> should be something like this.
SQL> select owner, table_name, tablespace_name, cluster_name from all_tables where rownum < 2;

OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME ----- ---------- --------------- ------------ SYS UNDO$ SYSTEM SQL> This is required to output a CSV file from a query. I can do a string concatenation of all the columns with a comma in between, but sure there is a 4000 or someother limit to that? Received on Thu Oct 28 2004 - 12:25:56 CEST

Original text of this message