How can I determine if a string is numeric in SQL?

by

You can use REGEXP_LIKE:

SELECT 1 FROM DUAL
WHERE REGEXP_LIKE('23.9', '^\d+(\.\d+)?$', '')

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. Is it possible to output a SELECT statement from a PL/SQL block?
  3. Pivoting rows into columns dynamically in Oracle
  4. Using ‘case expression column’ in where clause
  5. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  6. Concatenate results from a SQL query in Oracle
  7. How to use BOOLEAN type in SELECT statement
  8. How to kill a running SELECT statement
  9. Execute Immediate within a stored procedure keeps giving insufficient priviliges error
  10. Selecting the second row of a table using rownum
  11. Update with Join query in Oracle
  12. How to count the number of occurrences of a character in an Oracle varchar value?
  13. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  14. Finding rows that don’t contain numeric data in Oracle
  15. Is it possible to see the structure of mulitple table with a single “desc”.
  16. Function return sys_refcursor call from sql with specific columns
  17. Oracle date “Between” Query
  18. ORA-01861: literal does not match format string
  19. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  20. Query a Table’s Foreign Key relationships
  21. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  22. How to get multiple counts with one SQL query?
  23. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  24. T-SQL – Insert Data into Parent and Child Tables
  25. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  26. Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?
  27. How to find current transaction level?
  28. Select without a FROM clause in Oracle
  29. Error: The used SELECT statements have a different number of columns
  30. Update rows in one table with data from another table based on one column in each being equal

Leave a Comment