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: Suppressing a column

Re: Suppressing a column

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 14 Aug 1998 16:59:38 +0200
Message-ID: <6r1jbh$c33$1@newton.a2000.nl>


>Is there a way of suppress a table column ?

In a select in SQL*Plus?

    column name noprint
    select *
    from employee;

If you want to hide a column from the users (for example when using DESC in SQL*Plus), make a view.

Arjan. Received on Fri Aug 14 1998 - 09:59:38 CDT

Original text of this message

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