© Jouni Huotari ja Tapani Δijδnen
49
SQL:2003 - GENERATED ALWAYS
•Esimerkki:
–CREATE TABLE EMPLOYEES (
–EMP_ID INTEGER,
–SALARY DECIMAL(7,2),
–BONUS DECIMAL(7,2),
–TOTAL_COMP GENERATED ALWAYS AS (
–SALARY + BONUS ),
–HR_CLERK GENERATED ALWAYS AS (
–CURRENT_USER )
–)