如何用一个SQL得到一条记录如下:name a,b,c CREATE OR REPLACE FUNCTION get_name(temp_id number) RETURN VARCHAR2 IS Col_name VARCHAR2(4000); BEGIN FOR cur IN (SELECT name FROM t=temp_id ) LOOP Col_name := Col_name||cur.name; END LOOP; RETURN Col_name; END; select get_name(id) from t;
不错,可以先定义一个函数,然后在处理。 不过tgm78的选择语法应该更改为select id,get_name(id) name from t group by id;,
RETURN VARCHAR2
IS
Col_name VARCHAR2(4000);
BEGIN
FOR cur IN (SELECT name FROM t=temp_id ) LOOP
Col_name := Col_name||cur.name;
END LOOP;
RETURN Col_name;
END;
select get_name(id) from t;
不过tgm78的选择语法应该更改为select id,get_name(id) name from t group by id;,