YashanDB EMPTY_BLOB 函数

CREATE TABLE LOB_EMPTY_BLOB (clob1 CLOB,blob2 BLOB);INSERT INTO LOB_EMPTY_BLOB VALUES('1234','234');SELECT clob1,blob2 FROM LOB_EMPTY_BLOB;
CLOB1                                                            BLOB2                                                            ---------------------------------------------------------------- ---------------------------------------------------------------- 1234                                                             0234                                                        UPDATE LOB_EMPTY_BLOB SET clob1 = EMPTY_CLOB(), blob2 = EMPTY_BLOB();SELECT clob1,blob2 FROM LOB_EMPTY_BLOB;
CLOB1                                                            BLOB2                                                            ---------------------------------------------------------------- ----------------------------------------------------------------                                                                                                                                                                                 

-- 查询LENGTH(EMPTY_BLOB())SELECT LENGTH(EMPTY_BLOB()) res FROM DUAL;
                 RES--------------------                   0