1. À¥¿¡¼­ º¸´Â ¹æ¹ý...
=====================
select dbms_lob.substr(Ä÷³¸í, dbms_lob.getlength(Ä÷³¸í),1) Ä÷³º°Äª 
from TableName 
where .....

2. ÇÁ·ÒÇÁÆ®¿¡¼­ º¸´Â ¹æ¹ý.
=========================
SQL> set long 10000
SQL> select * from clob1
     where dbms_lob.instr(clobcol, 'Oracle9i Application Server')>0;