select from dual, typecasted
Date: Mon, 25 May 2009 02:18:37 -0700 (PDT)
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