{"id":201780,"date":"2024-11-11T00:49:58","date_gmt":"2024-11-11T00:49:58","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-check-if-column-value-is-numeric-in-oracle\/"},"modified":"2024-11-11T00:49:58","modified_gmt":"2024-11-11T00:49:58","slug":"how-to-check-if-column-value-is-numeric-in-oracle","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-check-if-column-value-is-numeric-in-oracle\/","title":{"rendered":"How to check if column value is numeric in Oracle?"},"content":{"rendered":"

To check if a column value is numeric in Oracle, you can use the REGEXP_LIKE function. Here is an example query that checks if the “column_name” is numeric:<\/p>\n

“`
\nSELECT *
\nFROM your_table
\nWHERE REGEXP_LIKE(column_name, ‘^[0-9]+$’);
\n“`<\/p>\n

This query will return rows where the “column_name” contains only numeric characters.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n