An unhandled error has occurred.
Reload
X
UIZFORGE
Exams
Pricing
Career Paths
Resources
EN
Login
Sign Up
1
/ 5
Advanced
A table has a virtual column TOTAL_PAY defined from salary and commission. A developer wants to store a manually entered value in TOTAL_PAY during INSERT. What should the DBA explain?
Insert any value and Oracle will store it if it matches the expression.
Do not insert into it directly; Oracle derives it from its expression.
Use ALTER SESSION SET virtual_columns=manual first.
Only SYS can update virtual columns with SQL*Plus.
AI Tutor
Stuck? Get a hint
