Wednesday, September 16, 2015

Oracle Query to Replace Special Characters from a string

SELECT REGEXP_REPLACE('##$!%*~``$123&&!!__!','[^[:alnum:]'' '']', NULL) FROM dual

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Query to list the Oracle RICEW Objects

Pass the application short name &APP_SHORT_NAME parameter to find RICE objects for the particular application and include any exclusion ...