you can simply check ascii value of each character in your string. if it is between 48 and 57 then it contains a number.
Regards, Paras. On Sat, May 7, 2011 at 1:03 PM, Gopakumar Pandarikkal <pandarik...@gmail.com > wrote: > sorry when did not allow any function :( > > > > On Sat, May 7, 2011 at 1:01 PM, Gopakumar Pandarikkal < > pandarik...@gmail.com> wrote: > >> * * 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. >> >> >> >> >> > > > -- > 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 > -- 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
