Home » RDBMS Server » Server Administration » case insensitive search in LOB
case insensitive search in LOB [message #372983] Tue, 20 March 2001 18:11
Christoph Kempen
Messages: 1
Registered: March 2001
Junior Member
I found the way to search for a string in a LOB:

SELECT ID
FROM test_3clob
WHERE DBMS_LOB.INSTR(CLOB1, 'Hi')>0;

But is there a way to search case-insentitive. In a
like you can do a UPPER(). But that doesn;t seem
to work on a CLOB :-(

Christoph...

Report message to a moderator

Previous Topic: Re: ORA-01562
Next Topic: performance of views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 23 03:26:34 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.