Well I don't see much effort in any kind of customization this script (for example adding NOT in front of every BETWEEN or just look at ascii table - easily googled)
On 30.11.2009 13:17, Niraj Singh The King wrote: > I really appreciate the approach but it would be more greatful if this > function could really return the special characters if encountered in > loop. > -- > Thanks and Regards, > Opus Software Solution(Pune) > Niraj Singh Parihar > Mobile Number : +919890492566. > > > > On Mon, Nov 30, 2009 at 1:20 PM, Andrej Hopko <ado.ho...@gmail.com > <mailto:ado.ho...@gmail.com>> wrote: > > I made this on to work: > > SET SERVEROUTPUT ON; > DECLARE > v_word VARCHAR2(30) := 'OR%^$&*AC&^LE'; > v_out VARCHAR2(30) := ''; > v_chr VARCHAR2(1); > BEGIN > FOR i IN 1..length(v_word) > LOOP > v_chr := SUBSTR(v_word,i,1); > IF v_chr BETWEEN 'A' AND 'Z' THEN > v_out := v_out || v_chr; > END IF; > IF v_chr BETWEEN 'a' AND 'z' THEN > v_out := v_out || v_chr; > END IF; > IF v_chr BETWEEN '0' AND '9' THEN > v_out := v_out || v_chr; > END IF; > END LOOP; > DBMS_OUTPUT.PUT_LINE(v_out); > END; > / > SET SERVEROUTPUT OFF; > > tried also regular expressions but not enough time to play ;-) > > hoppo > > On 30.11.2009 8:22, Niraj Singh The King wrote: > > Please help me in providing a sample code to remove special > characters > > from a string > > > > For E.g if i give string "OR%^$&*AC&^LE" the o/p should be "ORACLE" > > -- > > Thanks and Regards, > > Niraj Singh Parihar > > Mobile Number : +919890492566. > > > > -- > > 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 <mailto:Oracle-PLSQL@googlegroups.com> > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > <mailto: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 > <mailto:Oracle-PLSQL@googlegroups.com> > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > <mailto: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 -- 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
