Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: select without column names, whitespaces

Re: select without column names, whitespaces

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 10 Nov 2004 21:05:47 +0100
Message-ID: <cmr80f$d2q$2@news3.zwoll1.ov.home.nl>


jason_at_cyberpine.com wrote:

> Newbie here.
>
> How do I select without column names?
> How do I remove any white spaces from select output?
>
> Thanks.

What tool(s)?
SQL*Plus would need set head[ings] off.
Look up trim and concatenation (|)

-- 

Regards,
Frank van Bortel
Received on Wed Nov 10 2004 - 14:05:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US