Cast a varchar2(4000) column as varchar2(200)
Posted on 2006-11-07
Hi you experts,
I have a view looks like the following.
create or repace view EMP_V as
concate_addr( city,address1,address2) addr_desc
The addr_desc is now defined as varchar2(4000) by the database.
I know that I can cast it into varchar2(200) by using the CAST function in Oracle9i/10g:
cast(concate_addr( city,address1,address2) as varchar2(200))
But how can I do it in Oracle8i ?
Thanks in advance.