我试着写了一个函数,如下:
create or replace function fnfullname(tmp_id int)
return varchar2 is
pname varchar2(8);
begin
for a in (select name from partinfotest where id select distinct fnfullname(4) from partinfotest;
FNFULLNAME(4)
--------------------------------------------------------------------------------
无锡,滨海,胡埭
非常感谢,还想问一下,如何能在输出的时候显示成如下格式呢?
SQL> select distinct fnfullname(4) from partinfotest;
FNFULLNAME(4)
--------------------------------------------------------------------------------
无锡
滨海
胡埭