how to preserve the order when using UNION
709949Oct 24 2012 — edited Oct 24 2012Hi,
I'm combining three queries using the UNION operator.
for ex:
select 'a' from DUAL
union
select 'd' from DUAL
union
select 'b' from DUAL
union
select 'c' from dual;
I would like to see the same order as
a
d
b
c
but it is showing as
a
b
c
d
is it possible without using ORDER BY clause?
Please give some idea.
Thanks,
Kiran