oracle的clob,blob,noclob数据类型的初探

1.从表wfprocessdefine中查找processdefcontent,但是查出来的结果并不让我满意。因为结果数据为

<?xml version="1.0" encoding="GB2312"?>
<autoGraphics>    <graphic name="wfFyybS

没有看到我想看到的东西。而且PROCESSDEFCONTENT的查毒为

SQL> edit;
已写入 file afiedt.buf

  1* select dbms_lob.getlength(processdefcontent) from wfprocessdefine where processdefid=261
SQL> /

DBMS_LOB.GETLENGTH(PROCESSDEFCONTENT)
-------------------------------------
                               107760

SQL> edit;
已写入 file afiedt.buf

  1* select processdefcontent from wfprocessdefine where processdefid=261
SQL> /

PROCESSDEFCONTENT
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="GB2312"?>
<autoGraphics>    <graphic name="wfFyybS