SAP hana empty CLOB

1.6k views Asked by At

How can I fetch all the rows from a table, where the CLOB content is empty (but not null)? Table crate statement:

create column table "MY_SCHEM"."ISA_TMP"( "tenant_alias" varchar(500),"local_data" CLOB null);

I tried:

select * from "MY_SCHEM"."ISA_TMP"
where local_data = '';
1

There are 1 answers

0
Lars Br. On

You can check that by using the length() function:

SELECT * 
FROM ISA_TMP
WHERE length(local_data) = 0;