Oracle 12.1 - update column max value dynamically

Question

Sometimes I need to set number type column value as max value

Because I need to allow all values and I can't use negative value. Examples:

For number(1) -> 9

For number(1,2) -> 9.99

Can I update column max value dynamically based on column type?

   Update table set x= ?maxvalue?

Answer 1

I would suggest to use default value.

Alter table your_table modify your_col number(1) default 9;

Now, you can update value to default value.

Update your_table 
Set your_col = default
Where ..

Same way you can do it for column with data type number(1,2) with default value as 9.99

Cheers!!