Re: oracle hidden columns?

stephenvong_at_yahoo.com (stephen) wrote in message news:<a37c624a.0305091141.40b3944b_at_posting.google.com>...
> Hi,
>
> I was going to create a new field on all my tables to support
> multiple-column context searches, but my manager doesn't want me to
> create a new field on all the table because it will affect everyone
> else who is using our database. I was inform that Oracle have hidden
> fields on every table? They created these hidden fields for OLS? I
> am not using OLS and I would like to know what are these hidden
> fields. I would like to use these hidden fields if I can, instead of
> creating a new field. The only field that I know of is irow. If you
> know the answer, please send your reply to stephenvong_at_yahoo.com
>
> Thanks,
> Stephen

Oracle doesn't have 'hidden' columns, and your manager should better go back the school. One of the main features of a RDBMS is that an ALTER TABLE doesn't affect other users AT ALL (unless you use views like select * from table, which Oracle advises expressly against)

Sybrand Bakker
Senior Oracle DBA Received on Tue May 13 2003 - 09:33:50 CEST