{"type":"rich","categories":["DB"],"image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F12%2F08%2F064440\" title=\"\u30ab\u30e9\u30e0\u8ffd\u52a0\u6642\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u5024 - 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>","width":"100%","provider_url":"https://hatena.blog","title":"\u30ab\u30e9\u30e0\u8ffd\u52a0\u6642\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u5024","blog_title":"HTN20190109\u306e\u65e5\u8a18","blog_url":"https://htn20190109.hatenablog.com/","author_url":"https://blog.hatena.ne.jp/HTN20190109/","description":"Oracle (12cR1) drop table tab1 purge;create table tab1(col1 int); insert into tab1 values(1);commit;select * from tab1; alter table tab1 add (col2 int);alter table tab1 add (col3 int not null);\u2192ORA-01758: \u5fc5\u9808\u5217(NOT NULL)\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u3001\u8868\u3092\u7a7a\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 alter table tab1 add (col4 int default 123);alter table tab\u2026","provider_name":"Hatena Blog","height":"190","url":"https://htn20190109.hatenablog.com/entry/2019/12/08/064440","author_name":"HTN20190109","published":"2019-12-08 06:44:40","version":"1.0"}