I want to create a table which has hiredate and Interval of hiredate and sysdate. How to create a column that automaticlaly stores the calculation.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I don't believe you can.
The expression you use to create a virtual column must be deterministic, i.e. always return the same value when called with the same arguments. Involving the current date is fundamentally incompatible with that requirement.
You could use a plain old view though.