SQL> insert into test_control values ('Line 1 with tab'||chr(9)||'in it and then a return '||chr(10)||'for Line 2');

1 row created.

SQL> insert into test_control values ('Line with no control characters');

1 row created.

SQL> select rownum, a1 from test_control;

    ROWNUM A1
---------- ----------------------------------------
         1 Line 1 with tab      in it and then a return

           for Line 2

         2 Line with no control characters


SQL> select rownum, rowid, a1 from test_control
  2  where regexp_like (a1, '[[:cntrl:]]');

    ROWNUM ROWID              A1
---------- ------------------ ----------------------------------------
         1 AAAMMTAAEAAAABoAAA Line 1 with tab   in it and then a return

                              for Line 2

select rownum, rowid, a1 from test_control
where regexp_like (a1, '[ [:cntrl:] ]');

SQL> select 'michel', dump('michel') from dual;
'MICHE DUMP('MICHEL')
------ ------------------------------------
michel Typ=96 Len=6: 109,105,99,104,101,108

1 row selected.

select regexp_instr('abcfer'||chr(7)||'asdr'||chr(10)||'sss','[url=/wiki/:cntrl:]:cntrl:[/url]',1,level)
      ,dump(regexp_substr('abcfer'||chr(7)||'asdr'||chr(10)||'sss','[url=/wiki/:cntrl:]:cntrl:[/url]',1,level))
from dual connect by level <= 100;

SQL> create table test_control (id number, a1 varchar2(60));

Table created.

SQL> insert into test_control values
  2     (1, 'Line with tab'||chr(9)||'and a return '||chr(10)||'for Line 2');

1 row created.

SQL> insert into test_control values
  2     (2, 'Line with no control characters');

1 row created.

SQL> insert into test_control values
  2     (3, 'Line with heading'||chr(1)||'and '||chr(27)||' escape character');

1 row created.

SQL> insert into test_control values
  2     (4, 'Line with shift in '||chr(15)||'and shift out'||chr(14));

1 row created.

SQL> select * from test_control;

        ID A1
---------- ----------------------------------------
         1 Line with tab        and a return
           for Line 2

         2 Line with no control characters
         3 Line with headingand scape character
         4 Line with shift in and shift out


SQL> select distinct id,
  2     regexp_instr(a1, '[[:cntrl:]]', 1, level) cntrl_char_position,
  3     ascii(regexp_substr(a1, '[[:cntrl:]]', 1, level)) cntrl_char
  4  from test_control
  5  where regexp_like (a1, '[[:cntrl:]]')
  6  connect by regexp_substr(a1, '[[:cntrl:]]', 1, level) is not null
  7  order by 1;

        ID CNTRL_CHAR_POSITION CNTRL_CHAR
---------- ------------------- ----------
         1                  14          9
         1                  28         10
         3                  18          1
         3                  23         27
         4                  20         15
         4                  34         14

6 rows selected.

SELECT emp_Name,
       Regexp_instr(emp_Name,':cntrl:') cntrl_Char_Position,
       Ascii(Regexp_substr(emp_Name,':cntrl:')) cntrl_Char
FROM   emp_Item
WHERE  Regexp_like(emp_Name,':cntrl:');

select distinct id,
       regexp_instr(a1, '[url=/wiki/:cntrl:]:cntrl:[/url]', 1, level) cntrl_char_position,
       ascii(regexp_substr(a1, '[url=/wiki/:cntrl:]:cntrl:[/url]', 1, level)) cntrl_char
from  (select *
       from   test_control
       where  regexp_instr(a1,'[url=/wiki/:cntrl:]:cntrl:[/url]') > 0)
where regexp_like (a1, '[url=/wiki/:cntrl:]:cntrl:[/url]')
connect by regexp_substr(a1, '[url=/wiki/:cntrl:]:cntrl:[/url]', 1, level) is not null
 order by 1;

SQL> select * from  test_control ;
        ID A1
---------- ------------------------------------------------------------
         1 Line with tab        and a return
           for Line 2
         2 Line with no control characters
         3 Line with heading
and  escape character
         4 Line with shift in and shift out

4 rows selected.

SQL> select distinct id,
  2         regexp_instr(a1, '[[:cntrl:]]', 1, level) cntrl_char_position,
  3         ascii(regexp_substr(a1, '[[:cntrl:]]', 1, level)) cntrl_char
  4  from  (select *
  5         from   test_control
  6         where  regexp_instr(a1,'[[:cntrl:]]') > 0)
  7  where regexp_like (a1, '[[:cntrl:]]')
  8  connect by regexp_substr(a1, '[[:cntrl:]]', 1, level) is not null
  9   order by 1;
        ID CNTRL_CHAR_POSITION CNTRL_CHAR
---------- ------------------- ----------
         1                  14          9
         1                  28         10
         3                  18          1
         3                  23         27
         4                  20         15
         4                  34         14

6 rows selected.

select distinct id,
         regexp_instr(a1, '[[:cntrl:]]', 1, level) cntrl_char_position,
         ascii(regexp_substr(a1, '[[:cntrl:]]', 1, level)) cntrl_char
  from  (select *
         from   test_control
         where  regexp_instr(a1,'[[:cntrl:]]') > 0)
  connect by regexp_substr(a1, '[[:cntrl:]]', 1, level) is not null
  order by 1;