Functions to convert a key value pair to a formatted string #91
Description
The functions are mainly useful for logging.
Example:
v_foo := 42;
-- returns a string: '(v_foo = 42)'
kvn('v_foo', v_foo);
kv('v_foo', v_foo);
v_bar := null;
-- returns a string: '(v_bar = NULL)'
kvn('v_bar', v_bar);
-- returns an empty string (null)
kv('v_bar', v_bar);
Proposed function declarations for common types:
--
-- Return a string: (p_key = p_value) and if p_value is null: (p_key =
-- NULL). Useful for logging.
--
function kvn(p_key in varchar2, p_value in varchar2) return varchar2;
function kvn(p_key in varchar2, p_value in number) return varchar2;
function kvn(p_key in varchar2, p_value in date,
p_fmt in varchar2 default 'YYYY-MM-DD HH24:MI:SS')
return varchar2;
function kvn(p_key in varchar2, p_value in boolean) return varchar2;
--
-- Return a string: (p_key = p_value) and empty string (null) if p_value is
-- null. Useful for logging.
--
function kv(p_key in varchar2, p_value in varchar2) return varchar2;
function kv(p_key in varchar2, p_value in number) return varchar2;
function kv(p_key in varchar2, p_value in date,
p_fmt in varchar2 default 'YYYY-MM-DD HH24:MI:SS')
return varchar2;
function kv(p_key in varchar2, p_value in boolean) return varchar2;