clear markdown compare help best fiddles feedback dbanow.uk
≡
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805490 fiddles created (40772 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)