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 (40515 in the last week).
select * from V$VERSION;
BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0
…
hidden batch(es)
CREATE TABLE table1 (col1 VARCHAR (50), col2 INT);
✓
hidden batch(es)
INSERT INTO table1 VALUES ('ABC', 1);
1 rows affected
hidden batch(es)
INSERT INTO table1 VALUES ('DEF', 2);
1 rows affected
hidden batch(es)
WITH cte1 (x, y) AS ( SELECT col1, col2 FROM table1 WHERE col1 = (SELECT 'ABC' FROM dual) ) SELECT * FROM cte1;
X
Y
ABC
1
…
hidden batch(es)