#author("2019-11-06T12:52:55+08:00","default:Admin","Admin") .NET Framework
Web開発
Database
IoT
Oracle
定義:
create or replace function test RETURN NUMBER IS rtn NUMBER; BEGIN if rtn is NULL then dbms_output.put_line('NULL'); end if; return rtn; END;
実行:
select nvl(test(),0) from dual
コメント: