Oracle PL/SQL Dump Function

The Dump Function syntax:

dump( expression, [return_format], [start_position], [length] )

Example:

select dump('test') from dual;
Typ=96 Len=4: 116,101,115,116

select dump('test',10) from dual;
Typ=96 Len=4: 116,101,115,116

select dump('test',16) from dual;
Typ=96 Len=4: 74,65,73,74

select dump('test',1016) from dual;
Typ=96 Len=4 CharacterSet=WE8MSWIN1252: 74,65,73,74

select dump('test',1017) from dual;
Typ=96 Len=4 CharacterSet=WE8MSWIN1252: t,e,s,t