If you want a string of length 20 wouldn't CHAR(20) be appropriate?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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
Received on Tue Jan 06 2004 - 07:18:49 CST
