clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
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. 541809 fiddles created (11236 in the last week).

SELECT * FROM dual d JOIN dual d2 ON (d.dummy=d2.dummy)
DUMMY DUMMY
X X
 hidden batch(es)


CREATE TABLE tab AS SELECT 'X' AS dummy FROM dual;
1 rows affected
 hidden batch(es)


SELECT d.*, d2.* FROM tab d JOIN tab d2 ON (d.dummy=d2.dummy)
DUMMY DUMMY
X X
 hidden batch(es)