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
