Home » SQL & PL/SQL » SQL & PL/SQL » CLOB+test on NULL
CLOB+test on NULL [message #1942] Wed, 12 June 2002 06:08 Go to next message
yann
Messages: 3
Registered: September 2000
Junior Member
How is it possible to test if a CLOB is NULL?
I tried with the function DBMS_LOB.instr but it doesn't work!
Cheers
Re: CLOB+test on NULL [message #1943 is a reply to message #1942] Wed, 12 June 2002 06:13 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try this

select id from tableX
where dbms_lob.getlength(clob_col) is null;
Previous Topic: Problem with Inner Join (converting SQL from Access)
Next Topic: Cascading Trigger
Goto Forum:
  


Current Time: Thu Mar 28 13:11:29 CDT 2024