Re: How to set the size of string returned by PL/SQL functions?

On Oct 4, 9:37 am, "John Heitmuller." <john.heitmul..._at_jrfcorp.net> wrote:
> > create or replace view ..... as
> > select ...,..., ..., ... ,cast(myfunc(myparam) as varchar2(15))
> > mycol, ... from ... where ...;
>
> Brilliant! Thanks, David.

You could also use substr , as in create or replace view .. as ....select ....substr(param,1,15) as param ... from ...

-Madhu Sreeram Received on Thu Oct 04 2007 - 13:45:11 CDT