Welcome to the Oracle community forum and interact with 2 million technical staff. 1. Find the method selectcount (*) fromgame_articletwheredbms_lob.instr (t. content, utl_raw.cast_to_raw (convert (duowan.com, utf8), 1, 1) 0 or select
Welcome to the Oracle community forum, and interact with 2 million technical staff> go to 1. Find the method of select count (*) from game_article t where dbms_lob.instr (t. content, utl_raw.cast_to_raw (convert ('duowan. com ', 'utf8'), 1, 1) 0 or select
Welcome to the Oracle community forum and interact with 2 million technical staff> enter
1. Find the method in which the Clob field contains the specified record
Select count (*) from game_article t
Where dbms_lob.instr (t. content, utl_raw.cast_to_raw (convert ('duowan. com', 'utf8'), 1, 1)> 0
Or
Select count (*) from game_article t
Where dbms_lob.instr (t. content, 'duowan. com ', 1, 1)> 0
2. How can I determine whether the oracle large field (clob) is null?
Select * from a where x is null or dbms_lob.getlength (x) = 0
DBMS_LOB is a package dedicated to processing large objects.
DBMS_LOB.GETLENGTH is used to check the data type size of a large object.