Oracle虚拟列测试

1、新建虚拟列

alter table t_ext add t_viral generated always as (user_id*10) virtual;

exec dbms_stats.gather_table_stats( ownname =>'zxb', tabname =>'t_ext')

2、查看虚拟列

SELECT TABLE_NAME,COLUMN_NAME, DATA_TYPE, HIDDEN_COLUMN, DATA_DEFAULT FROM USER_TAB_COLS WHERE TABLE_NAME = 'T_EXT';

3、删除虚拟列，一定加括号

exec DBMS_STATS.DROP_EXTENDED_STATS ( ownname =>'zxb', tabname =>'t_ext', extension =>'(USER_ID*10)');