"Frank Y" <dmx_frank_at_yahoo.com> wrote in message
news:9d599275.0401052027.495c4690_at_posting.google.com...
> Hello there,
>
> I am using Oracle 9i on Windows 2000 Server. I need to create an
> operator to return a string with length 20.
>
> If I use the following statement:
> CREATE OPERATOR test ....
> RETURN VARCHAR2....
> ...
>
> the return string has a default length 4000.
>
> Does any one know to make the return string length 20?
>
>
> thanks a lot.
>
> Frank
You could always try lpad to pad your string out to a length of 20, if
that's what your asking.
Received on Tue Jan 06 2004 - 06:50:44 CST
