Re: Suppressing a column

From: <psylvestre_at_my-dejanews.com>
Date: Mon, 17 Aug 1998 12:04:55 GMT
Message-ID: <6r9697$9h5$1@nnrp1.dejanews.com>

Hello,

Thanks for answering,

But what you answered is not exactly what i expected, because i want to suppress physically a column in a table.

That's mean that all the datas corresponding to the column will be suppress. So the column will not exist.

Thanks in advance.

In article <6r1jbh$c33$1_at_newton.a2000.nl>, "Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
> >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.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 17 1998 - 07:04:55 CDT