Subquery
October 24, 2019 1 Comment
with x as (select sysdate from dual)
select * from utter_bollocks.x;
Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design … (Now with added Sets Appeal)
October 24, 2019 1 Comment
with x as (select sysdate from dual)
select * from utter_bollocks.x;
Filed under oracle, sql, subquery factoring, with clause
Oh, I didn’t realise that! schema is ignored. nice.
Embedded abuse to amuse and annoy whomever is debugging your code.