コメント |
@DIV
CREATE or REPLACE FUNCTION 社員数
RETURN VARCHAR2
AS
RET_VALUE VARCHAR2(20);
RET_VALUE1 NUMBER;
RET_VALUE2 NUMBER;
BEGIN
BEGIN
select count(*) into RET_VALUE1 from "社員マスタ";
EXCEPTION
WHEN OTHERS THEN
RET_VALUE := 0;
END;
BEGIN
select count(*) into RET_VALUE2 from "商品マスタ";
EXCEPTION
WHEN OTHERS THEN
RET_VALUE := 0;
END;
RET_VALUE := RET_VALUE1 || ',' || RET_VALUE2;
RETURN RET_VALUE;
END 社員数;
@END
|