Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is this sql reference valid?

Re: Is this sql reference valid?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 20 May 2005 11:02:10 -0700
Message-ID: <1116609294.287571.41900@o13g2000cwo.googlegroups.com> 





why don't you try it yourself?



Oracle Database 10g Release 10.1.0.2.0 - Production



SQL> select substr('12345',6,2) , nvl(substr('12345',6,2),'NULL') from
dual;



S NVL(



- ----


  NULL


SQL>



Ed.
Received on Fri May 20 2005 - 13:02:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US