Hi, I need to change the value in a field when this value is null with value 1, beacuse is false. (SQL APEX)
Example:
| Area_1 | Cod_1 | Div (Cod_1/Area_1)
|
|---|
| 10 | 50 | 5 |
| 5 | 25 | 5 |
| null | 10 | error |
I need this result:
| Area_1 | Cod_1 | Div (Cod_1/Area_1) |
|---|
| 10 | 50 | 5 |
| 5 | 25 | 5 |
| 1 | 10 | 10 |