ITPub博客

SQL> create table test (id number,name blob); Table created SQL> create table test2 (id number,name clob); Table created SQL> insert into test values (111,rawtohex('hello')); ...

DBMS_LOB.LOADBLOBFROMFILE(从BFILE加载内容到BLOB)[oracle@blliu ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Sun May 23 16:01:58 2010Copyright (c) 1982, 2010, Oracle.  All ...

SQL> desc test1; Name                             ...

[oracle@blliu ~]$ sqlplus test/testSQL*Plus: Release 10.2.0.4.0 - Production on Sat Feb 27 13:27:07 2010Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g ...