Oracle Error ORA-22817: subquery not allowed in the default clause

Oracle Error Message

ORA-22817: subquery not allowed in the default clause

Reason for the Error

An attempt was made to use a subquery in the column default clause expression.

Solution

Remove the subquery from the default clause.