Oracle12c 虚拟列

 

 

ALTER TABLE INVENTORY_TRANSACTION ADD (HANDLE2 AS (SITE || '-' || TO_char(CREATED_DATE_TIME, 'YYYYMMDDHH24MISS') ));