The DBMS_LOB package provides a set of procedures and functions to access and manipulate LOBs from within PL/SQL programs.搜索一下以前的帖子吧
解决方案 »
- 三个想通过oracle(plsql)实现的查询
- 问一条sql语句,如何写
- 插入大对象的SQL语句怎么写?
- oracle错误
- 在两个库创建两个相同的视图,可是执行性能不一样
- 我的UPDATE要30多个小时,有没有好办法,强人进!
- 我该怎么下载oracle9i的官方文档,我怎么下都不下下来。
- oracle安装时遇到的怪问题,亟待各位高手解决,我真的不想采用格盘重装系统的不是办法的办法
- Oracle9i 的导出(exp)问题...急!!
- Oracle Database11g怎么设置并使用外部的JDK1.8
- 出现这个错误信息Unable to retrieve astring from the report Builder message file
- PB7和Oracle8.0.4的连接问题
key NUMBER PRIMARY KEY,
clob_col CLOB,
blob_col BLOB,
bfile_col BFILE
);DELETE FROM lobdemo
WHERE key IN (50, 51, 60, 61);-- The following two INSERTs will add twp rows to the table.
INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
VALUES (50, 'This is a character literal',
HEXTORAW('FEFEFEFEFEFEFEFEFEFE'),
NULL);INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
VALUES (51, 'This is another character literal',
HEXTORAW('ABABABABABABABABABAB'),
NULL);-- We can also do INSERTs with the results of a query. The
-- following will copy rows 50 and 51 to 60 and 61.
INSERT INTO lobdemo
SELECT key + 10, clob_col, blob_col, NULL
FROM lobdemo
WHERE key IN (50, 51);-- This statement will update blob_col to a new value.
UPDATE lobdemo
SET blob_col = HEXTORAW('CDCDCDCDCDCDCDCDCDCDCDCD')
WHERE key IN (60, 61);-- And finally, we can delete row 61.
DELETE FROM lobdemo
WHERE key = 61;COMMIT;