Search code examples
blobhsqldb

what is counter part of empty_blob() of Oracle DB in HSQLDB?

I am using a query in oracle in which I clean the blobs on regular intervals as:

Update table XYZ set ColumnABC= EMPTY_BLOB() where <<<<conditions>>>>

What to write in HSQLDB in place of empty_blob()

Solution

  • The empty SQL binary string, X'' can be used in place of an empty blob. You can write the EMPTY_BLOB() function using this string:

    CREATE FUNCTION EMPTY_BLOB() RETURNS BLOB
    RETURN CAST(X'' AS BLOB);