SQL> with text as
  2    (select 'Hello' col from dual union
  3     select 'Foobar' from dual
  4    )
  5  select chr(42) ||' '|| col result
  6  from text;

RESULT
--------
* Foobar
* Hello

SQL>

SQL> select level, chr(level)
  2  from dual
  3  connect by level <= 255;

     LEVEL C
---------- -
         1 ☺
         2 ☻
         3 ♥
         4 ♦
         5 ♣
         6 ♠
         7
         8
         9
        10
        11 ♂
        12 ♀
        13
        14 ♫
        15 ☼
        16 ►
...

* sdfjasklfjsaldfjaslfddas
  sjdfkasjdflasfjdasklfjaslf

* sdfjsladfj

CURSOR CUR_Liste IS
  select chr(42) ||'    '|| V_listText
	from dual;

SQL> create or replace function f_split (par_col in varchar2)
  2    return varchar2
  3  is
  4    retval varchar2(1000);
  5  begin
  6    for i in 0 .. length(par_col) / 50 loop
  7      retval := retval ||
  8                case when i = 0 then '*  '
  9                     else            '   '
 10                end ||
 11                substr(par_col, 50 * i, 50) || ' '|| chr(10);
 12    end loop;
 13    return (retval);
 14  end f_split;
 15  /

Function created.

SQL> with test as
  2    (select 1 id,
  3       'Back to the Future is a 1985 American science fiction adventurecomedy film.' ||
  4       ' It was directed by Robert Zemeckis, produced by Steven Spielberg, and stars' col
  5       from dual
  6     union
  7     select 2,
  8       ' Michael J. Fox, Christopher Lloyd, Lea Thompson and Crispin Glover'
  9      from dual
 10     union
 11     select 3,
 12       'The film tells the story of Marty McFly' col
 13      from dual
 14    )
 15  select f_split(col)
 16  from test
 17  order by id;

F_SPLIT(COL)
--------------------------------------------------------------------------------
*  Back to the Future is a 1985 American science fict
   tion adventurecomedy film. It was directed by Robe
   rt Zemeckis, produced by Steven Spielberg, and sta
   rs

*   Michael J. Fox, Christopher Lloyd, Lea Thompson a
   and Crispin Glover

*  The film tells the story of Marty McFly



SQL>