* * DECODE(*replace*(translate(variable,'1234567890','##########'),'#'),* NULL*,'NUMBER','NON NUMER') ='NON NUMER'
this condition will check if your variable is non number regards gopakumar Pandarikkal On Fri, May 6, 2011 at 7:04 PM, mallikarjuna D <techinfoma...@gmail.com>wrote: > select case when length(translate(string,'!1234567890','!'))-length(string) > <0 then 'numeric have' > else 'no numeric') from dual > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- Gopakumar P.G. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
