Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- adapted from http://stackoverflow.com/a/28820388/315385
- SELECT
- *
- FROM krim_role_mbr_t
- WHERE
- REGEXP_LIKE(role_mbr_id, '^[[:digit:]]+$')
- ORDER BY
- TO_NUMBER(role_mbr_id) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement