Re: Oracle gurus..please help with UNION query

Alex Shnir wrote:
>
> Just like this:
>
> select int1, int2, char3, char4, int5, char6 from aaa
> UNION
> select int_01, 0, '', char_01, 0, 'aaaaaaaaaaaa' from bbb
>
> > Only make sure that your dummy is matching the datatype

You can also use TO_NUMBER(null) etc, ;-)))

--
/Sanoff ^\Quit(coredump) Received on Sat Jul 17 1999 - 18:05:12 CDT