开发者

Read a few megabytes from a BLOB in Oracle

开发者 https://www.devze.com 2023-01-11 07:24 出处:网络
I wish to extract a sub-BLOB (a few MBs) from a BLOB in Oracle. The question \"read first 1kb of a blob from oracle\" doesn\'t help me, since I need to get more 开发者_StackOverflow中文版bytes than D

I wish to extract a sub-BLOB (a few MBs) from a BLOB in Oracle.

The question "read first 1kb of a blob from oracle" doesn't help me, since I need to get more 开发者_StackOverflow中文版bytes than DBMS_LOB.SUBSTR can give me (it returns RAW, which supports only a few thousand bytes).


Use DBMS_LOB.READ(lob_loc, amount, offset, buffer)

0

精彩评论

暂无评论...
验证码 换一张
取 消