advanced code snippet search

Posted By

geekzspot on 12/05/12


Tagged


Versions (?)

Oracle Is Integer

 / Published in: SQL
 

Check if a value is an integer using a POSIX Regular Expression

Expand | Embed | Plain Text 
  1. SELECT * FROM locations WHERE REGEXP_LIKE(postal_code, ^[[:digit:]]+$');

Report this snippet  

You need to login to post a comment.