Re: select from dual, typecasted
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: Mon, 25 May 2009 13:49:46 +0200
Message-ID: <1243252207.637439_at_proxy.dienste.wien.at>
jodleren wrote:
> I need to typecast one item, as I select from dual union something
> else...
>
> select '1' as amount from dual
> union select ....
>
> where it should be:
>
> select longvarchar('1') as amount from dual
>
> how do I achieve that?
Date: Mon, 25 May 2009 13:49:46 +0200
Message-ID: <1243252207.637439_at_proxy.dienste.wien.at>
jodleren wrote:
> I need to typecast one item, as I select from dual union something
> else...
>
> select '1' as amount from dual
> union select ....
>
> where it should be:
>
> select longvarchar('1') as amount from dual
>
> how do I achieve that?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions016.htm
Yours,
Laurenz Albe
Received on Mon May 25 2009 - 06:49:46 CDT