Thankx alot Andrej -- Thanks and Regards, Opus Software Solution(Pune) Niraj Singh Parihar Mobile Number : +919890492566.
On Mon, Nov 30, 2009 at 5:56 PM, Andrej Hopko <ado.ho...@gmail.com> wrote: > 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> 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 > > -- > 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
