Tuesday 11 November 2008

Oracle: Checking a column is numeric

select * from table1
where
ltrim(rtrim(translate(col1,'0123456789-.',' '))) is not null

Posted by Ook at 02:38

Labels:

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)