数据仓库服务 GAUSSDB(DWS)-LOB函数:DBMS_LOB.SUBSTR

时间：2024-06-29 17:51:35

数据仓库服务 GAUSSDB(DWS) 系统函数

DBMS_LOB.SUBSTR

DBMS_LOB.SUBSTR通过配置参数MigDbmsLob，用户可以指定迁移此函数还是直接保留。

输入：DBMS_LOB.SUBSTR，MigDbmsLob设为true

如果参数MigDbmsLob设为true，则迁移。相反，如果参数MigDbmsLob设为false，则不迁移。

输入

SELECT dbms_lob.substr('!2d3d4dd!',1,5);

输出

If the config param is true, it should be migrated as below:
select substr('!2d3d4dd!',5,1);

If false, it should be retained as it is:
select dbms_lob.substr('!2d3d4dd!',1,5);

输入

SELECT dbms_lob.substr('!2d3d4dd!',5);

输出

If the config param is true, it should be migrated as below:
select substr('!2d3d4dd!',1,5);

If false, it should be retained as it is:
select dbms_lob.substr('!2d3d4dd!',5);

上一篇：数据仓库服务 GAUSSDB(DWS)-LOB函数:DBMS_LOB.FREETEMPORARY

下一篇：数据仓库服务 GAUSSDB(DWS)-LOB函数:DBMS_LOB.FREETEMPORARY