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,
SYSTEM SQL> should be something like this.
SQL> select owner, table_name, tablespace_name, cluster_name from all_tables where rownum < 2;
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