Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hidden virtual column created by FBI: Is the column name stable?

User_1871May 17 2022

In a related question, @user-h3j7u mentioned:
If you create a FBI, virtual column is added implicitly.

create table t1(n number);
create index i1 on t1(abs(n));
insert into t1 values (-123);
commit;
col column_name format a15
select column_name, hidden_column, virtual_column from user_tab_cols where table_name='T1';

COLUMN_NAME HID VIR


N NO NO
SYS_NC00002$ YES YES

select n, SYS_NC00002$ from t1;

          N SYS\_NC00002$

       -123          123

Question:
Is the name of that hidden virtual column stable? In other words, when I upgrade from Oracle 18c to the latest version, will the SYS_NC00002$ name change?
Use case:
Possibly explicitly referring to the virtual column name in a query's SELECT clause.

Comments

Post Details

Added on May 17 2022
5 comments
220 views