Showing posts with label UTL_URL. Show all posts
Showing posts with label UTL_URL. Show all posts
Saturday, May 22, 2021
In this post, we have given an example usage of UTL_URL standard
package for encoding or decoding a URL. Hope it helps!!
Custom Wrapper Function:
CREATE OR REPLACE FUNCTION encode_decode_url (p_url IN VARCHAR2, p_action IN VARCHAR2 ) RETURN VARCHAR2 AS BEGIN IF p_url IS NULL THEN RETURN NULL; END IF; IF p_action = 'ENCODE' THEN RETURN utl_url.escape(p_url, TRUE); ELSIF p_action = 'DECODE' THEN RETURN utl_url.unescape(REPLACE(p_url, '+', ' ')); ELSE RETURN 'Error: Invslid Action'; END IF; END encode_decode_url;
Sample Run:
Saturday, May 22, 2021 0
Subscribe to:
Posts (Atom)
