1
ALTER TABLE TAB_NAME ADD TEST_COL VARCHAR2(255);
ALTER TABLE TAB_NAME MODIFY TEST_COL GENERATED ALWAYS as ('some_exp') VIRTUAL; 

Second script gives an error:

Error report -
ORA-54026: Real column cannot have an expression
54026. 0000 -  "Real column cannot have an expression"
*Cause:    Attempted to alter a real column to have an expression.
*Action:   This is not valid, change the DDL.
Raushan
  • 113
  • 2

0 Answers0