Skip to content

Instantly share code, notes, and snippets.

@kjunichi

kjunichi/20161118.md

Last active January 13, 2017 06:03
Show Gist options
  • Save kjunichi/5c585803ce1108483c5f7b937e8c90a6 to your computer and use it in GitHub Desktop.
Save kjunichi/5c585803ce1108483c5f7b937e8c90a6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
20161118.md

Oracleで指定した項目に数値以外が含まれているレコードを取得する

select * from foo f where (regexp_like(f.item_id , '[^0-9]'))

関連

アクセス解析タグ

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment