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

samir.vds@xxxxxxxxxxxxxx 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


The SQL written above will not work as written. It has two FROM clauses.

If you want to hid a column in the output, then simply remove that column in the SELECT clause. You are not required to show that column, but your SELECT clause needs to show at least one column.

Additionally, just because your SQL statement returns the column does not mean your application has to display that column. The other answer shows how you can disable this in SQL*Plus. If you are writing your own application, you do not have to display the column's value in that application if you do not want to.


HTH,
Brian

--
===================================================================

Brian Peasland
dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
.

Relevant Pages

  • Re: FieldByRealName
    ... Hovewer I am not sure that this ... >> known by the alias. ... I take it the SQL query is not ... >> Ray Marron ...
    (borland.public.delphi.database.ado)
  • Re: See the structure of what I am pulling via DBI
    ... > sure how to see the arrayref. ... if you know the field name or its alias you can use $sth->fetchrow_hashref ... and you have access to the sql query ...
    (perl.beginners)
  • Re: fetching boolean value from sql query result
    ... fetching the field values? ... DataReaderbut this field number could so easily change if the ... sql query is changed and ... ... > Please do not send e-mail directly to this alias. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: [PHP] Counting Occurrences within an If statement
    ... statement in the SQL query so you don't return so many rows. ... I am pulling 7500 rows from a MySQL database, but I only want to display a ... display a row in a table ...
    (php.general)
  • Re: Combo box question
    ... Rowsource to "table.field1, field2" ... If you don't want to display the id field, set the width of that column to ... can use it in your sql query. ...
    (microsoft.public.fox.vfp.forms)