oos-utils/source/packages/oos_util_string.pks at 87cb1e7f0b1057640cd75386859a37c22c1b6430 · OraOpenSource/oos-utils · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
create or replace package oos_util_string
as

  -- TYPES
  /**
   * @type tab_vc2 VC2 Nested table
   * @type tab_vc2_arr VC2 associated array
   */
  type tab_vc2 is table of varchar2(32767);
  type tab_vc2_arr is table of varchar2(32767) index by pls_integer;

  -- CONSTANTS
  /**
   * @constant gc_default_delimiter Default delimiter for delimited strings
   * @constant gc_cr Carriage Return
   * @constant gc_lf Line Feed
   * @constant gc_crlf Use for new lines.
   */
  gc_default_delimiter constant varchar2(1) := ',';
  gc_cr constant varchar2(1) := chr(13);
  gc_lf constant varchar2(1) := chr(10);
  gc_crlf constant varchar2(2) := gc_cr || gc_lf;

  function to_char(
    p_val in number)
    return varchar2
    deterministic;

  function to_char(
    p_val in date)
    return varchar2
    deterministic;

  function to_char(
    p_val in timestamp)
    return varchar2
    deterministic;

  function to_char(
    p_val in timestamp with time zone)
    return varchar2
    deterministic;

  function to_char(
    p_val in timestamp with local time zone)
    return varchar2;

  function to_char(
    p_val in boolean)
    return varchar2
    deterministic;

  function truncate(
    p_str in varchar2,
    p_length in pls_integer,
    p_by_word in varchar2 default 'N',
    p_ellipsis in varchar2 default '...')
    return varchar2;

  function sprintf(
    p_str in varchar2,
    p_s1 in varchar2 default null,
    p_s2 in varchar2 default null,
    p_s3 in varchar2 default null,
    p_s4 in varchar2 default null,
    p_s5 in varchar2 default null,
    p_s6 in varchar2 default null,
    p_s7 in varchar2 default null,
    p_s8 in varchar2 default null,
    p_s9 in varchar2 default null,
    p_s10 in varchar2 default null)
    return varchar2;

  function sprintf(
    p_str in varchar2,
    p_key_values in t_tab_key_value,
    p_left_pattern in varchar2 default '{',
    p_right_pattern in varchar2 default '}')
    return varchar2;

  function sprintf(
    p_str in varchar2,
    p_tab_vc2 in t_tab_vc2,
    p_left_pattern in varchar2 default '{',
    p_right_pattern in varchar2 default '}')
    return varchar2;

  function string_to_table(
    p_string in clob,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_vc2_arr;

  function string_to_table(
    p_string in varchar2,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_vc2_arr;

  function listunagg(
    p_string in varchar2,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_vc2 pipelined;

  function listunagg(
    p_string in clob,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_vc2 pipelined;

  function reverse(
    p_string in varchar2)
    return varchar2;

  function ordinal(
    p_num in number)
    return varchar2;

end oos_util_string;
/