17,382
社区成员




DROP TABLE b;
CREATE TABLE b (ID int,num NUMBER,CONVERT NUMBER);
INSERT INTO b VALUES(1,80,1.1);
INSERT INTO b VALUES(2,78,2.1);
INSERT INTO b VALUES(3,29,3.1);
COMMIT;
SELECT * FROM b;
CREATE OR REPLACE FUNCTION G(vID NUMBER) RETURN VARCHAR2 AS
R_STR VARCHAR2(20);
BEGIN
SELECT '(' || NUM || '*' || CONVERT || ')'
INTO R_STR
FROM B
WHERE ID = vID
AND ROWNUM = 1;
RETURN R_STR;
END;
/
SELECT g(1)||'+'||g(2)||'+'||g(3) FROM dual;
给你个代码学习:
DROP TABLE b;
CREATE TABLE b (ID int,num NUMBER,CONVERT NUMBER);
INSERT INTO b VALUES(1,80,1.1);
INSERT INTO b VALUES(2,78,2.1);
INSERT INTO b VALUES(3,29,3.1);
COMMIT;
SELECT * FROM b;
CREATE OR REPLACE FUNCTION G(vID NUMBER) RETURN VARCHAR2 AS
R_STR VARCHAR2(20);
BEGIN
SELECT '(' || NUM || '*' || CONVERT || ')'
INTO R_STR
FROM B
WHERE ID = vID
AND ROWNUM = 1;
RETURN R_STR;
END;
SELECT g(1)||'+'||g(2)||'+'||g(3) FROM dual;
create or replace function aaa() return number
is
total number;
begin
select sum(num*convert) into total from a;
return total;
end;