Re: Adding a hidden column to a table and hidden tables in Oracle

Good point. Thanks,
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Brian E Dick" <bdick_at_cox.net> wrote in message
news:H%iT9.21347$t06.775994_at_news2.east.cox.net...


> Columns omitted by a view must be either nullable or not null with a

> default.


>

> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message

> news:UbhT9.622568$WL3.193043_at_rwcrnsc54...

> > They aren't hidden if you have rights to them. Just create tables and

 don't


> > give rights. Then the user won't see them.  For hidden columns you

 create
 a


> > view on a table and leave the column out.

> > Jim


> >

> > --

> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com

> > with family.  Remove the negative part, keep the minus sign.  You can

 figure


> > it out.

> > "tolga toonja" <tolgatoonja_at_yahoo.com> wrote in message

> > news:857fe98f.0301090615.70d4f208_at_posting.google.com...

> > > Hi All,

> > > Oracle has hidden tables with starting the character '$'.

> > > I wonder (if possible) how to:

> > > - create a hidden table or

> > > - create a hidden column of a non-hidden table

> > > as an Oracle 8i, 9i admin.

> > > Thank you in advance.

> > > Tolga

> >

> >

>

>