{"type":"rich","description":"Oracle\u3067char\u307e\u305f\u306fvarchar2\u306e\u6587\u5b57\u5217\u30d5\u30a3\u30fc\u30eb\u30c9 NAME VARCHAR2(32) (NULL\u53ef) \u306b\u5bfe\u3057\u3066\u3001\u300cnull\u307e\u305f\u306f\u30b9\u30da\u30fc\u30b9\u6587\u5b57\u5217\u300d\u3068\u3044\u3046\u6761\u4ef6\u3067\u554f\u3044\u5408\u308f\u305b\u3092\u884c\u304a\u3046\u3068\u3057\u3066\u3001\u6b21\u306e\u3088\u3046\u306aWHERE\u53e5\u3092\u66f8\u3044\u305f\u3002 WHERE NAME IS NULL OR LTRIM(RTRIM(NAME)) = '' \u3053\u308c\u3060\u3068\u3001NAME\u304cnull\u306e\u5834\u5408\u3057\u304b\u5f15\u3063\u304b\u304b\u3089\u306a\u3044\u3002TRIM\u304c\u52b9\u3044\u3066\u3044\u306a\u3044\u306e\u304b\u3068\u304b\u3001\u3044\u308d\u3044\u308d\u60a9\u3093\u3060\u304c\u3001\u3053\u3046\u3059\u308b\u3068\u4e0a\u624b\u304f\u3044\u304f\u3053\u3068\u304c\u5206\u304b\u3063\u305f\u3002 WHERE NAME IS NULL OR LTRIM(NAME) IS NULL \u3064\u307e\u308a\u3001Oracle\u3067\u306f\u7a7a\u6587\u5b57\u5217\u3068\u6587\u5b57\u5217\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u2026","image_url":null,"blog_title":"argius note","version":"1.0","author_name":"argius","provider_url":"https://hatena.blog","height":"190","categories":["database"],"title":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7a7a\u6587\u5b57\u5217","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fargius.hatenablog.jp%2Fentry%2F20050711%2F1121090704\" title=\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7a7a\u6587\u5b57\u5217 - argius note\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://argius.hatenablog.jp/entry/20050711/1121090704","author_url":"https://blog.hatena.ne.jp/argius/","published":"2005-07-11 23:05:04","provider_name":"Hatena Blog","width":"100%","blog_url":"https://argius.hatenablog.jp/"}