The CREATE FUNCTION ` getParentList ` (` rootId ` VARCHAR (10000)) RETURNS a VARCHAR (10000) CHARSET utf8
The BEGIN
DECLARE sParentList VARCHAR (10000); DECLARE sParentTemp VARCHAR (10000); The SET sParentTemp=rootId; WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
The SET sParentList=CONCAT (, sParentList sParentTemp, ', '); The ELSE
The SET sParentList=CONCAT (sParentTemp); END the IF; The SELECT GROUP_CONCAT (from_classifier_id) INTO sParentTemp FROM t_mm_relation_comp WHERE FIND_IN_SET (to_classifierid sParentTemp) & gt; 0; END WHILE; RETURN sParentList; END
;;


Ask how the Oracle stored function into a Java method? thank you

CodePudding user response:

This is a mysql syntax,

In Java, what kind of structure your data is stored?


PS: do you want to give you a mobile to Java area?

CodePudding user response:

This is a mysql syntax,

In Java, what kind of structure your data is stored?


PS: do you want to give you a mobile to Java area?