看看replace 函数的原始说明吧: Both search_string and replacement_string, as well as char, can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype and is in the same character set as char. 好像不支持long类型。虽然能够select出较短的值。
Both search_string and replacement_string, as well as char, can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype and is in the same character set as char.
好像不支持long类型。虽然能够select出较短的值。
今天问了我的DBA朋友,他也说oracle里面关于replace函数的定义,对long函数不起作用。
今天问了我的DBA朋友,他也说oracle里面关于replace函数的定义,对long函数不起作用。