Home » SQL & PL/SQL » SQL & PL/SQL » UN -ENTERABLE FIELD
UN -ENTERABLE FIELD [message #1037] Sat, 23 March 2002 08:24 Go to next message
SA
Messages: 37
Registered: March 2002
Member
HELLO FRIENDS,
MY TABLE HAS A FIELD A ,I WANT THIS FIELD NOT TO BE ENTERABLE .GIVE ME QUERY. THANKYOU.

Report message to a moderator

Re: UN -ENTERABLE FIELD [message #1060 is a reply to message #1037] Tue, 26 March 2002 09:35 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
Unfortunately SQL*PLUS is not yet a GUI tool with Fields and all..

anyway you can do this..
create table test1
(a varchar2(1), b varchar2(1));

Create view view1 as select a from test1;

desc view1
(column b is hidden in view)

Report message to a moderator

Previous Topic: how to get list of objects which are using a table
Next Topic: dbms_job
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 11:12:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.