{"published":"2019-01-30 00:40:58","description":"Oracle create or replace function func1 return integer as ret integer; begin select nvl(max(col1),0) into ret from tab1; return ret;exception when others then return -1;end;/ select func1 from dual; MySQL SHOW FUNCTION STATUS\\Gshow create function func1; CREATE FUNCTION func1 (s CHAR(20))RETURNS CHA\u2026","version":"1.0","type":"rich","blog_title":"HTN20190109\u306e\u65e5\u8a18","url":"https://htn20190109.hatenablog.com/entry/2019/01/30/004058","author_name":"HTN20190109","height":"190","categories":["DB"],"width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F01%2F30%2F004058\" title=\"\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/HTN20190109/","image_url":null,"title":"\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3","blog_url":"https://htn20190109.hatenablog.com/","provider_url":"https://hatena.blog","provider_name":"Hatena Blog"}