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.