clear markdown feedback
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)