?
快捷搜索:  as  test  1111  test aNd 8=8  test++aNd+8=8  as++aNd+8=8  as aNd 8=8

和記娛h188下載app手機版:Oracle如何對CLOB行字段執行全文檢索

?

大年夜家知道,跨越4000字的文本一樣平常存儲在CLOB中(MSQL、Sysbase是寄放在Text中),在今朝的Oracle版本(Oracle8i)和記娛h188下載app手機版中,對大年夜字段CLOB仍舊不支持在where子句直接的like操作,若何實現對存儲在CLOB字段中的內容進行like查找呢?下面的文章或則能給你贊助。雖然在SQL*PLUS中能實現用select直接看到CLOB的內容,然則若何經由過程DBMS_LOB包實現對中文情況下的CLOB內容的讀取我不停沒有找到好的措施(應用Documents中提到的Samples只適用英翰墨符集),這極大年夜的限定了應用第3方軟件開拓事情的自由度。假如那位仁兄有高著兒盼望Email給我。

表布局:create table products(

productid number(10) not null ,

name varchar2(255) 和記娛h188下載app手機版,

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 proce和記娛h188下載app手機版dure 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.

FILEEXISTS function Checks if the file exists on the server.

FILEGETNAME procedure Gets the directory alias and file name.

FILEISOPEN function Checks if the file was opened using the input BFILE locators.

FILEOPEN procedure Opens a file.

FREETEMPORARY procedure Frees the temporary BLOB or CLOB in the user′s default temporary tablespace.

GETCHUNKSIZE function Returns the amount of space used in the LOB chunk to store the LOB value.

GETLENGTH function Gets the length of the LOB value.

INSTR function Returns the matching position of the nth occurrence of the pattern in the LOB.

ISOPEN function Checks to see if the LOB was already opened using the input locator.

ISTEMPORARY function Checks if the locator is pointing to a temporary LOB.

LOADFROMFILE procedure 和記娛h188下載app手機版Loads BFILE d和記娛h188下載app手機版ata into an internal LOB.

OPEN procedure Opens a LOB (internal, external, or temporary) in the indicated mode.

READ procedure Reads data from the LOB starting at the specified offset.

SUBSTR function Returns part of the LOB value starting at the specified offset.

TRIM procedure Trims the LOB value to the specified shorter length.

WRITE procedure Writes data to the LOB from a specified offset.

WRITEAPPEND procedure Writes a buffer to the end of a LOB.

免責聲明:以上內容源自網絡,版權歸原作者所有,如有侵犯您的原創版權請告知,我們將盡快刪除相關內容。

您可能還會對下面的文章感興趣:

快三平台开户