Question

teradata 能创建函数吗

Answer 1

DECLARE
t_name VARCHAR2(10);
t_course1 NUMBER;
t_course2 NUMBER;
t_course3 NUMBER;
TYPE c_type IS REF CURSOR;
cur c_type;

BEGIN
OPEN cur FOR
\\'SELECT t_name,
SUM(CASE t_course WHEN \\'\\'\\'||\\'语文\\'||\\'\\'\\' THEN t_score ELSE 0 END),
SUM(CASE t_course WHEN \\'\\'\\'||\\'数\\'||\\'\\'\\' THEN t_score ELSE 0 END),
SUM(CASE t_course WHEN \\'\\'\\'||\\'物理\\'||\\'\\'\\' THEN t_score ELSE 0 END)
FROM tb GROUP BY t_name\\';
LOOP
FETCH cur INTO t_name,t_course1,t_course2,t_course3;
EXIT WHEN cur%NOTFOUND;
dbms_output.put_line(t_name||\\'语文\\'||t_course1||\\'数\\'||t_course2||\\'物理\\'||t_course3);

END LOOP;
CLOSE cur;
END;

给参考例参数换OKgood luck