Re: simple question about UNION statement
From: justme <someq_at_rogers.com>
Date: Fri, 26 Apr 2002 01:41:54 GMT
Message-ID: <Cf2y8.14831$Il1.13765_at_news02.bloor.is.net.cable.rogers.com>
Date: Fri, 26 Apr 2002 01:41:54 GMT
Message-ID: <Cf2y8.14831$Il1.13765_at_news02.bloor.is.net.cable.rogers.com>
no, but you can convert the numbers to a char ..
select 'a' from dual
union
select to_char(1) from dual
"Sanjin" <sanjin.m_at_SoftHome.net> wrote in message
news:aaa1hf$5bhh$1_at_as201.hinet.hr...
> Is it possible to use UNION statement (with Oracle) with fields which
> doesn't have the same data type?
>
> Thanks in advance
>
> Sanjin
>
>
Received on Fri Apr 26 2002 - 03:41:54 CEST