Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: number only
How about nvl instead of decode(length()...
Quoting Stephane Faroult <sfaroult_at_roughsea.com>:
> RTF SQL Reference, functions, TRANSLATE(). With a pinch of
> DECODE(LENGTH(),
> 0, 999, ...) it should do.
> Regards,
>
> Stephane Faroult
>
-- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Jun 30 2004 - 09:00:32 CDT
![]() |
![]() |