SQL> desc memberinfo_use
Name Type Nullable Default Comments
---------------- ------------- -------- ------- --------
MEMBERID VARCHAR2(11) Y
REMARK CLOB Y
SQL> spool c:\1.txt
Started spooling to c:\1.txt
SQL> select memberid,remark from memberinfo_use where rownum < 2;
SQL> desc memberinfo_use
Name Type Nullable Default Comments
---------------- ------------- -------- ------- --------
MEMBERID VARCHAR2(11) Y
REMARK CLOB Y
SQL> spool c:\1.txt
Started spooling to c:\1.txt
SQL> select memberid,remark from memberinfo_use where rownum < 2;