Jump to content
ChetanaSforum
Sign in to follow this  
samitsaurabh

Good Questions in Oracle

Recommended Posts

hi everybody,,, Could anyone suggest me how to remove numeric value or ASCII characters from a string or viceversa.......eg :- String:-1@3A$^B2&DS!output should be :- ABDSor output should be :- 132

Share this post


Link to post
Share on other sites

hi everybody,,, Could anyone suggest me how to remove numeric value or ASCII characters from a string or viceversa.......eg :- String:-1@3A$^B2&DS!output should be :- ABDSor output should be :- 132

try this queryselect translate('1@3A$^B2&DS!','1@3$^2&!',' ') from dual;it will ask "enter value for ds"...enter as DS....output will be ABDS....this is as per ur requirement....if not thn try ro explain ur question well.....regards..

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  



×