Newbie here.

How do I select without column names?
How do I remove any white spaces from select output?

Thanks.

jason@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

jason@cyberpine.com wrote in message news:<ef0a04d7.0411091117.1d59e144@posting.google. com>...
> Newbie here.
>
> How do I select without column names?
> How do I remove any white spaces from select output?
>
> Thanks.

Select * will select all column names in the table

If by "without column names" you mean supressing the headings in
SQLPlus then see the SET command in the SQLPlus Users Guide and
Reference for set heading off and/or set pagesize 0.

To remove or change the column separator see the SET command again.
There is a parameter for the column separator. I think it is called
colsep.

If you are going to work in Oracle then there is no excuse for not
reading the SQLPlus Users Guide and Reference; it is full of useful
features.

HTH -- Mark D Powell --

jason@cyberpine.com wrote:

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

If you are in a class ... do your homework.

If you have a job go to http://tahiti.oracle.com and look it up.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)