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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
210 views