Конвертация clob to varchar2 Oracle DB
SELECTNAME, TO_CHAR(DBMS_LOB.substr(body_template, 3600, 1)) from t_notification_types;
SELECTNAME, TO_CHAR(DBMS_LOB.substr(body_template, 3600, 1)) from t_notification_types;