SELECT DM_MC FROM DM_DM WHERE DM_DMM=100; 这一句是有错误的: 应该是: select 字段1 Into dm_mc form dm_dm where dm_dmm-100;Into dm_mc 这个不能忘
有 Into 还不对,WHY?CREATE OR REPLACE FUNCTION AAA (DM_DMM IN NUMBER) RETURN VARCHAR2 IS D VARCHAR2; BEGIN SELECT DM_MC INTO D FROM DM_DM WHERE DM_DMM=100; RETURN DM_MC; END;
这一句是有错误的:
应该是:
select 字段1 Into dm_mc form dm_dm where dm_dmm-100;Into dm_mc 这个不能忘
RETURN VARCHAR2 IS D VARCHAR2;
BEGIN
SELECT DM_MC INTO D FROM DM_DM WHERE DM_DMM=100;
RETURN DM_MC;
END;