17,090
社区成员
发帖
与我相关
我的任务
分享
select t.deptno, t.dname, fun_test(t.deptno) sal_list from scott.dept t;
--------------------
1 10 ACCOUNTING |0|2450|5000|1300
2 20 RESEARCH |800|2975|3000|1100|3000
3 30 SALES |1600|1250|1250|2850|1500|950
4 40 OPERATIONS The result is null!
EXCEPTION
WHEN NOT_DATA_FOUND THEN
RETRUN 'NOT DATA'
WHEN OTHERS THEN
RETURN 'ERROR'