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

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
>
>
Received on Thu Jan 09 2003 - 19:16:07 CET