Firebird 4.0

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