OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » hide a column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

hide a column [message #373107]

Tue, 27 March 2001 16:37

CHACKO
Messages: 11
Registered: March 2001

Junior Member

How can be eliminate /Hide a column in sql?

Report message to a moderator

Re: hide a column [message #373113 is a reply to message #373107]

Wed, 28 March 2001 05:45

kavithask
Messages: 34
Registered: March 2001
Location: London

Member

Hi,

You can hide a column when you SQL*Plus by using the COLUMN command.

COL <colname> noprint

This will stop it from printing on the screen or to the spool file.

HTH
Kavitha

Report message to a moderator

Re: hide a column [message #373115 is a reply to message #373107]

Wed, 28 March 2001 06:05

John R
Messages: 156
Registered: March 2000

Senior Member

Create a view on the table which only selects the columns you want the users to see.
Revoke all rights to the underlying table from the users and grant them select on the view.

Report message to a moderator

Re: hide a column [message #373120 is a reply to message #373107]

Wed, 28 March 2001 09:18

Jaco
Messages: 23
Registered: August 2000

Junior Member

Hi,

I gave that command but it is not working

select k.*,col sal noprint from emp k;
Is this is right?
can you send this command please..I don't want sal column print but i need the remaing all columns. thanks

Report message to a moderator