[Oracle] CLOB to VARCHAR 조회

SELECT DBMS_LOB.SUBSTR([CLOB 컬럼명], 4000, 1)
  FROM [테이블]