CREATE FUNCTION `getParentList`(`rootId` VARCHAR(10000)) RETURNS varchar(10000) CHARSET utf8
BEGIN
DECLARE sParentList VARCHAR(10000);DECLARE sParentTemp VARCHAR(10000);SET sParentTemp =rootId;WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT(sParentTemp,',',sParentList);ELSE
SET sParentList = CONCAT(sParentTemp);END IF;SELECT GROUP_CONCAT(from_classifier_id) INTO sParentTemp FROM t_mm_relation_comp WHERE FIND_IN_SET(to_classifierid,sParentTemp)>0;END WHILE;RETURN sParentList;END
;;
请教如何将Oracle存储函数转为java方法? 谢谢
BEGIN
DECLARE sParentList VARCHAR(10000);DECLARE sParentTemp VARCHAR(10000);SET sParentTemp =rootId;WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT(sParentTemp,',',sParentList);ELSE
SET sParentList = CONCAT(sParentTemp);END IF;SELECT GROUP_CONCAT(from_classifier_id) INTO sParentTemp FROM t_mm_relation_comp WHERE FIND_IN_SET(to_classifierid,sParentTemp)>0;END WHILE;RETURN sParentList;END
;;
请教如何将Oracle存储函数转为java方法? 谢谢
PS:要不要给你移动到 Java区?
PS:要不要给你移动到 Java区?