Oracle 生成CSV Blob并将其存储在表中

SQL> create table t ( c clob );

Table created.

SQL> declare
  2    l_clob  clob;
  3    l_row   varchar2(4000);
  4  begin
  5    dbms_lob.createtemporary(l_clob, true);
  6    for i in ( select * from user_tables )
  7    loop
  8      l_row := i.table_name||','||i.num_rows||','||i.blocks||chr(10);
  9      dbms_lob.writeappend (l_clob, length(l_row), l_row);
 10    end loop;
 11
 12    insert into t (c) values ( l_clob );
 13
 14    dbms_lob.freetemporary(l_clob);
 15  end;
 16  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

C
---------------------------------------------------------------------------
JOB_PARAMS,1,5
JOB_LOG,2,5
PRODUCT,1,5
U_CSS_COLORFAM,4,5
RESULTS,500,5
EMP1,14,
复制