Oracle 判断为空 all space

You can use trim on the column.

where trim(product_type) is null

The above is not DBMS-independent, since Sybase does not provide the trim function. However, the below approach will work both in Sybase and Oracle:

where rtrim(ltrim(product_type)) is null