YashanDB EMPTY_CLOB 函数

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

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