专题文章
时长:00:00更新时间:2020-11-09 07:57:46
DB2递归SQL根据当前机构查询所有下属机构树:CREATE TABLE UNTECK_ORGANIZATION ( ID BIGINT NOT NULL, LEVEL_ INTEGER, NAME VARCHAR(64), AREACODE VARCHAR(8), ORGSEQ VARCHAR(128), PARENTID BIGINT, THESORT INTEGER, DESCN VARCHAR(256), DEL_FLAG INTEGER, CREATE_TIME TIMESTAMP, CREATE_USER V
查看详情