select from dual, typecasted

From: jodleren <>
Date: Mon, 25 May 2009 02:18:37 -0700 (PDT)
Message-ID: <>


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

Original text of this message