Db2 Developer-C 11.1
Firebird 3.0
Firebird 4.0
MariaDB 10.2 (unavailable)
MariaDB 10.3
MariaDB 10.4
MariaDB 10.5
MariaDB 10.6
MySQL 5.5
MySQL 5.6
MySQL 5.7
MySQL 8.0
Node.js 18
Oracle 11g Release 2
Oracle 18c
Oracle 21c
Postgres 8.4 (unavailable)
Postgres 9.3
Postgres 9.4
Postgres 9.5
Postgres 9.6
Postgres 10
Postgres 11
Postgres 12
Postgres 13
Postgres 14
Postgres 15 Beta 2
SQLite 3.8 (unavailable)
SQLite 3.16 (unavailable)
SQLite 3.27
SQLite 3.39
SQL Server 2012 (unavailable)
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019
SQL Server 2019 (Linux)
YugabyteDB 2.6
YugabyteDB 2.8
no sample DB
run
clear
markdown
feedback
MySQL 8.0
SQLite 3.27
Oracle 18c
Firebird 3.0
MariaDB 10.4
MySQL 5.7
MySQL 5.6
MySQL 5.5
MariaDB 10.3
Db2 Developer-C 11.1
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019
Oracle 21c
MariaDB 10.5
Oracle 11g Release 2
Node.js 18
MariaDB 10.6
SQL Server 2019 (Linux)
YugabyteDB 2.8
YugabyteDB 2.6
Postgres 12
Postgres 9.5
Postgres 11
Postgres 10
Postgres 9.6
Postgres 9.4
Postgres 13
Postgres 14
Postgres 9.3
Postgres 15 Beta 2
SQLite 3.39
Firebird 4.0
≡
clear
markdown
feedback
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
3364508 fiddles created (40495 in the last week).
create table t ( f1 numeric(10,3), f2 numeric(10,3), f3 numeric(10,3), f4 numeric(10,3) )
✓
✓
hidden batch(es)
insert into t values ( 60, 60, 60, 60 );
1 rows affected
1 rows affected
hidden batch(es)
select * from t;
F1
F2
F3
F4
60.000
60.000
60.000
60.000
…
F1
F2
F3
F4
60.000
60.000
60.000
60.000
…
hidden batch(es)
select f1*f2*f3*60 as product from t union all select f1*f2*f3*f4 as product from t;
PRODUCT
…
arithmetic exception, numeric overflow, or string truncation numeric value is out of range
PRODUCT
…
arithmetic exception, numeric overflow, or string truncation numeric value is out of range
hidden batch(es)