select LENGTH(REGEXP_REPLACE(orgseq, '\.', '')) FROM OM_ORGANIZATION
如1.2.3
结果为3
根据一个字段被分隔符分成几段,更新某字段。
update OM_ORGANIZATION om set (orglevel)= (select (LENGTH(REGEXP_REPLACE(orgseq, '\.', '')) )/4 FROM OM_ORGANIZATION oo where oo.orgid=om.orgid)