1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
SQL>
SQL> Create Table t_clob (
2 id Integer Primary key,
3 aclob Clob
4 )
5 /
Table created
SQL> Declare
2 l_bfile BFILE;
3 l_clob CLOB;
4 Begin
5 Insert Into t_Clob(id, aclob)
6 Values (1, empty_clob())
7 Return aclob Into l_clob;
8 l_bfile := Bfilename('TEMP','emp.csv');
9 dbms_lob.fileopen( l_bfile, dbms_lob.FILE_READONLY );
10 dbms_lob.loadfromfile(l_clob, l_bfile, dbms_lob.getlength(l_bfile) );
11 dbms_lob.fileclose( l_bfile );
12 End;
13 /
PL/SQL procedure successfully completed
SQL> Select id, dbms_lob.getlength(aclob)
2 From t_clob
3 /
ID DBMS_LOB.GETLENGTH(ACLOB)
--------------------------------------- -------------------------
1 649
SQL> |
Partager