select from dual, typecasted
From: jodleren <sonnich_at_hot.ee>
Date: Mon, 25 May 2009 02:18:37 -0700 (PDT)
Message-ID: <0bdbd84f-1c0e-4469-b7b2-a10650fb7da4_at_z9g2000yqi.googlegroups.com>
Hello
Date: Mon, 25 May 2009 02:18:37 -0700 (PDT)
Message-ID: <0bdbd84f-1c0e-4469-b7b2-a10650fb7da4_at_z9g2000yqi.googlegroups.com>
Hello
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?
/S Received on Mon May 25 2009 - 04:18:37 CDT