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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query: how can I hide a column in output?

Re: SQL query: how can I hide a column in output?

From: Anand Rao <panandrao_at_gmail.com>
Date: 16 Aug 2006 03:25:30 -0700
Message-ID: <1155723929.983010.220140@h48g2000cwc.googlegroups.com>


Yes it is possible with a simple command like this,

SQL> column client_no noprint

you will find this and more in the SQL *Plus User's Guide and Reference for 9i as well as 10g.

regards
anand

samir.vds_at_googlemail.com wrote:
> Hi everyone,
>
> as example, I've the following SQL query:
>
> select from hge123 client_no, client_name from client_tab
>
> Actually, I need the alias client_no for further processing, but I
> don't want to to see client_no as column in output. Is this somehow
> possible ?
>
>
> regards Samir
Received on Wed Aug 16 2006 - 05:25:30 CDT

Original text of this message

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