5 Mart 2014 Çarşamba

Oracle - How to find invalid number row

Following sql can help to find rows which contains invalid number


select  rowid as row_nums,
column_name
from
TABLE_NAME
where not
REGEXP_LIKE (column_name, '[[:digit:]]')

Hiç yorum yok:

Yorum Gönder