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> 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 > > 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 -- 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
