Shulou(Shulou.com)05/31 Report--

This article mainly introduces oracle how to query clob field data related knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe that everyone after reading this oracle how to query clob field data article will have a harvest, let's take a look.

In oracle, you can use the instr () function with select statement to query clob field data, and the instr function is used to determine whether the string contains the specified character. The syntax is "select*from table name. Instr (field name (clod type), query condition', 1prime1)".

The operating environment of this tutorial: Windows10 system, Oracle 11g version, Dell G3 computer.

How to query clob field data by oracle

Grammar

Select * from table_name where dbms_lob.instr (field name (clod type), 'query criteria', 1) > 0

Concrete examples

Select t.* t.rowid from * * BUSI_MESSAGE_LOG twheredbms_lob.instr (t.mesbody1) > 0

Grammatical interpretation

In Oracle, you can use the instr function to determine whether a string contains a specified character. Its syntax is:

Instr (sourceString,destString,start,appearPosition).

Eg: dbms_lob.instr (field name (clod type), 'query criteria', 1d1)

Where sourceString represents the field you want to query

DestString stands for query condition

Start represents the start of the search. This parameter is optional and defaults to 1.

AppearPosition indicates that you want to find the number of destString in the source character. This parameter is also optional. The default is 1.

If the value of start is negative, it means to look from right to left.

The return value is 0 if the target string is not found in the source string, or null if the source string or target string is null

In other cases, the actual position of the target string in the source string is returned

This is the end of the article on "how oracle queries clob field data". Thank you for reading! I believe you all have a certain understanding of "how to query clob field data in oracle". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.