Update Virtual column via SQL Workshop

PHOTO EMBED

Sat Jul 23 2022 02:03:26 GMT+0000 (UTC)

Saved by @Reemhel #sql

ALTER TABLE DAYSUM
  MODIFY V_TOT_REVN NUMBER GENERATED ALWAYS AS (ROUND(NVL("RM_REVN",0)+NVL("FB_REVN",0)+NVL("RM_UPGRADES",0)+NVL("OTHER_REVN",0)+NVL("DIVE_SERV",0)+NVL("DIVE_EQUIP",0),2)) VIRTUAL
content_copyCOPY