黑骑士

博客导航

博客日历

«	七月 2008					»
一	二	三	四	五	六	日
	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

如何操作blob字段？

发表人:wzy25 | 发表时间: 2008年四月15日, 16:31

最近碰到一个测试案例，测试standby的性能，当中有个特别测试blob字段效率的环节，正好整理了一个测试用程序，给大家分享一下。

lob类型，不管blob还是clob，在sql中，都可以直接当作varchar2来使用的。

比如下面的表

create table testlob(id number(2),b_l blob);
可以直接 insert into testlob values (1,'123');

当然更专业的是用下面的方式

这个案例把一个文件写入到blob，最典型的应用。

首先创建一个目录

create or replace directory mydir as 'd:';

declare
dest_loc blob;

--指定要读入的文件，在mydir目录下的
src_loc bfile := bfilename('MYDIR', 'ace_introdue.jpg'); --目录名字一定要大写
amount integer := 4000;
begin

--插入记录，同时返回blob的locator
insert into testlobvalues(2,empty_blob()) returning b_l into dest_loc;
--打开 bfile

dbms_lob.open(src_loc, dbms_lob.lob_readonly);

--获得文件长度
select dbms_lob.getlength(src_loc) into amount from dual;

--打开要写入记录的blob locator

dbms_lob.open(dest_loc, dbms_lob.lob_readwrite);

--直接把文件load到blob字段
dbms_lob.loadfromfile(dest_loc, src_loc,amount);

--关闭相应的locator

dbms_lob.close(dest_loc);
dbms_lob.close(src_loc);
commit;
end;
/

还是很简单的吗。

[回复]

Discount viagra online
viagra
https://www.blogger.com/comment.g?blogID=5577098518194103540&postID=8162644759575121838
[url=https://www.blogger.com/comment.g?blogID=5577098518194103540&postID=8162644759575121838]viagra[/url]

Viagra | 28/04/2008, 14:04

[回复]

Discount viagra online
viagra
https://www.blogger.com/comment.g?blogID=8290753909343683022&postID=7944080580789692023
[url=https://www.blogger.com/comment.g?blogID=8290753909343683022&postID=7944080580789692023]viagra[/url]

Viagra | 30/04/2008, 21:43

[回复]

Cheap cialis online
cialis
https://www.blogger.com/comment.g?blogID=8884434212950643172&postID=5916543911431987125
[url=https://www.blogger.com/comment.g?blogID=8884434212950643172&postID=5916543911431987125]cialis[/url]

Cialis | 01/05/2008, 06:57

[回复]

Discount viagra online
viagra
https://www.blogger.com/comment.g?blogID=9008154654445328645&postID=1593338179931985604
[url=https://www.blogger.com/comment.g?blogID=9008154654445328645&postID=1593338179931985604]viagra[/url]

Viagra | 02/05/2008, 05:15

[回复]

Cheap cialis online
cialis
https://www.blogger.com/comment.g?blogID=513494629458774789&postID=5066463426249996410
[url=https://www.blogger.com/comment.g?blogID=513494629458774789&postID=5066463426249996410]cialis[/url]

Cialis | 07/05/2008, 19:58

http://ca.youtube.com/user/achatviagra [回复]

http://ca.youtube.com/user/achatviagra

Generique viagra | 15/05/2008, 13:41

http://www.1medsonline.com no prescription low cost pharmacy [回复]

http://www.1medsonline.com no prescription low cost pharmacy

non prescription pharmacy | 18/05/2008, 18:55

Monroe, [回复]

Monroe,

Maxima Vaca | 22/05/2008, 22:49

order tramadol [回复]

order tramadol

tramadol hcl | 23/05/2008, 09:24

order tramadol [回复]

order tramadol

tramadol hcl | 23/05/2008, 09:25

It very useful!, Viagra, mnv, [回复]

It very useful!, Viagra, mnv,

Buy Viagra Online | 28/05/2008, 20:52

comment6, [回复]

comment6,

jonn1 | 06/06/2008, 15:30

comment2, [回复]

comment2,

jonn2 | 06/06/2008, 16:07

comment6, [回复]

comment6,

jonn3 | 06/06/2008, 17:23

comment3, [回复]

comment3,

jonn1 | 06/06/2008, 18:05

comment6, [回复]

comment6,

jonn3 | 06/06/2008, 18:43

comment4, [回复]

comment4,

jonn1 | 06/06/2008, 19:21

comment3, [回复]

comment3,

jonn1 | 06/06/2008, 20:00

comment6, [回复]

comment6,

jonn2 | 06/06/2008, 20:36

comment4, [回复]

comment4,

jonn1 | 06/06/2008, 21:13

buy tramadol online [回复]

buy tramadol online

no prescription | 12/06/2008, 23:33

buy tramadol online [回复]

buy tramadol online

no prescription | 12/06/2008, 23:34

Good Job, Generic Viagra, 614771, [回复]

Good Job, Generic Viagra, 614771,

Buy Viagra Online | 16/06/2008, 16:51

Respect Work, Buy Viagra Online, 35846, [回复]

Respect Work, Buy Viagra Online, 35846,

Buy Viagra Online | 16/06/2008, 17:42

Thank you very much. Very informative., women s facial hair, 6523, earl loose ohio, 9724, fairlaine grounds, 88564, satilite imiges, trgmu, barrister style bookcase, 042, bbw superstars free video, 8-))), uk bondage bob, bhayvt, outlook express setup for sbcglobal, 934047, ex315, ppcz, http://wallaschek.at/tutorials/help/screen.menumanager.html, 910, eastern traditional rendevous, 960, little suamico wisconsin inflatables, 806572, weapon of choice fatboy slim download, rhhvf, dogloo insulated cooler, :(, percy priest cabin, 678, jamacia brochures, 153, santa claus with sledge, qetzlr, shaved teens pd, 380, turanga leela porn, :(, zzr indicator relay part number, 7216, trailer hitch ford escort, %-DD, hot doggy sex, %))), osteopathic manipulative medicine workshop seminar, 113, sim lemonade millioniare cheats, avpae, dog licking gilr, :-[, [回复]

Margie | 06/07/2008, 06:44

http://cheap-tramadol.us/buy-tramadol.html [回复]

Nice site
http://cheap-tramadol.us/cheap-tramadol-online.html cheap tramadol online http://cheap-tramadol.us/order-tramadol-online.html order tramadol online

oprejhgko@yahoo.com | 06/07/2008, 07:36

If your ship doesn't come in, swim out to it! , angie savage freeones, 21145, male shirtless web, 533859, 52 nash healey, 3262, dennis moynihan gl v, 854, rosary novena cd, yqabem, mein lieblingsrapper blumio, yoa, breaman articles, >:-[, eric carle lesson plans music, :-PPP, http://www.diapress.dk/index 2h.html, >:-[[, naked in woods, =], http://obrzezameblowe.pl/FAS/newversion/index14_.html, laggg, women nudism activities, rlv, sitkins, gcm, balloony nipples, 17691, herbal vaginal health, 912, fat chick skinny guy, 8-((, zojila dish drainer, wbqwjf, amazon 5 themes of geo, uiln, northampton pa cemeteries, mvup, deanza expedition 1776, >:-P, map of brays bayou, :-))), amount of headstart teacher stipend texas, >:-)), leone lewis bleeding love, 988, lmm dpf system exhaust, %-)), myspade, mbxt, tendon lateral malleolus, =OO, booksforsale, 102239, bpi family bank foreclosure list, jdji, b everly mitchel naked, 5604, [回复]