[Oracle] URL encode / decode 사용하기

- - URL Encode function 

CREATE OR REPLACE FUNCTION form_url_encode(

  data    IN VARCHAR2,

  charset IN VARCHAR2) RETURN VARCHAR2 AS

BEGIN

  RETURN utl_url.escape(data, TRUE, charset); 

END;

-- URL Decode function

CREATE OR REPLACE FUNCTION form_url_decode(

  data    IN VARCHAR2,

  charset IN VARCHAR2) RETURN VARCHAR2 AS

BEGIN

  RETURN utl_url.unescape(replace(data, '+', ' '), charset);

END;