{"title":"\u30c8\u30ea\u30ac\u30fc","type":"rich","author_url":"https://blog.hatena.ne.jp/HTN20190109/","categories":["DB"],"description":"Oracle CREATE OR REPLACE TRIGGER trig1 BEFORE INSERT OR UPDATE OR DELETE ON tab1BEGIN CASE WHEN INSERTING THEN DBMS_OUTPUT.PUT_LINE('Inserting'); WHEN UPDATING THEN DBMS_OUTPUT.PUT_LINE('Updating'); WHEN DELETING THEN DBMS_OUTPUT.PUT_LINE('Deleting'); END CASE;END;/ set serveroutput on size 10000ins\u2026","blog_title":"HTN20190109\u306e\u65e5\u8a18","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F02%2F02%2F002516\" title=\"\u30c8\u30ea\u30ac\u30fc - 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>","provider_url":"https://hatena.blog","width":"100%","height":"190","published":"2019-02-02 00:25:16","url":"https://htn20190109.hatenablog.com/entry/2019/02/02/002516","blog_url":"https://htn20190109.hatenablog.com/","image_url":null,"version":"1.0","provider_name":"Hatena Blog","author_name":"HTN20190109"}