By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (
amount_num NUMERIC(5,2),
amount_dec DECIMAL(5,2)
);
EXECUTE BLOCK AS BEGIN
INSERT INTO test VALUES (97.12, 97.12);
INSERT INTO test VALUES (123.12, 123.12);
INSERT INTO test VALUES (1234.12, NULL);
INSERT INTO test VALUES (NULL, 1234.12);
END
4 rows affected
SELECT * FROM test;
| AMOUNT_NUM | AMOUNT_DEC |
|---|---|
| 97.12 | 97.12 |
| 123.12 | 123.12 |
| 1234.12 | null |
| null | 1234.12 |