Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query: how can I hide a column in output?
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