来源:Oracle认证 发布时间:2012-11-12 Oracle认证视频 评论
表结构:create table products(
productid number(10) not null ,
name varchar2(255) ,
description CLOB) ;
方法:SELECT productid, name FROM products
WHERE dbms_lob.instr(products.description,′some text′,1,1) > 0;
下面列出了DBMS_LOB包中的过程函数:
APPEND procedure Appends the contents of the source LOB to the destination LOB.
CLOSE procedure Closes a previously opened internal or external LOB.
COMPARE function Compares two entire LOBs or parts of two LOBs.
COPY procedure Copies all, or part, of the source LOB to the destination LOB.
CREATETEMPORARY procedure Creates a temporary BLOB or CLOB and its corresponding index in the user′s default temporary tablespace.
ERASE procedure Erases all or part of a LOB.
FILECLOSE procedure Closes the file.
FILECLOSEALL procedure Closes all previously opened files.
① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;
② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。