Hello!
please advise , how to create select with unions
when both selects should have the same inline view ?
In other words I would like to transfer the identifer synchronously for both inline views from external queiry,
how to do this in one statement ?
select column from
(select column from where id = "external_id" order by ...)
union all
select column from
(select column from where id = "external_id" order by ...)
I'm usung 11.2.0.3
Thanks and regards,
Pavel