UPDATE QS_SECTION_INFO set SERIAL_NUMBER= SUBSTR(SECTION_INFO_RULE,12,5) where PARENT ='8c76ac49250a430997e9ba47b6c7a258'
UPDATE QS_SECTION_INFO set SECTION_INFO_NAME= SUBSTR(SECTION_INFO_NAME,13,LENGTH(SECTION_INFO_NAME)-13) where PARENT ='8c76ac49250a430997e9ba47b6c7a258'
oracle数据库的SUBSTR的用法
最新推荐文章于 2024-06-23 15:02:59 发布