简单大对象
采用load导入进去
create table test(id int,b1 text,b2 byte); vi data.txt 1|1124tweg33|10101010101af| 2|1124tweg33|101011100101af| 3|1124tweg33|101111010101af| load from './data.txt' delimiter "|" insert into test;
智能大对象
----创建表 drop table if exists tb_struc; create table tb_struc( id int,bid bigint, did double precision,nid numeric, flag boolean,dt date, time_str timestamp, chr char(50),str varchar(50),str2 varchar2(50),bb blob,cb clob); ----插入数据 insert into tb_struc values(1,120000000000,1.23,1.23,1,today, sysdate, 'test str','test str','test str2',filetoblob('1.txt','client'),filetoclob('2.txt','client'));
--查询数据 select * from tb_struc;
