HEXTORAW:

INSERT INTO raw_table(raw_column) VALUES (HAXTORAW('017D3F');

CHARTOROWID:

SELECT per_nom from consolida_mes

where rowid = CHARTOROWID('AAAAenAAIAAAAdVVAAX');

RAWTOHEX:

SELECT rawtohex(raw_column) from raw_table;

ROWIDTOCHAR:

select rowidtochar(rowid) from consolida_mes

where rownum = 1;

TO_CHAR:

select to_char(sysdate,'dd/mm/yyyy') from dual;

TO_DATE:

select to_date('19/03/2011', 'dd/mm/yyyy') from dual;

TO_NUMBER:

select to_number('$123.45','$199.99') from dual;