check if “it’s a number” function in Oracle

by

One additional idea, mentioned here is to use a regular expression to check:

SELECT  foo 
FROM    bar
WHERE   REGEXP_LIKE (foo,'^[[:digit:]]+$');

The nice part is you do not need a separate PL/SQL function. The potentially problematic part is that a regular expression may not be the most efficient method for a large number of rows.

More Related Contents:

  1. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  2. What is the replacement of cursor foreach in oracle pl/sql?
  3. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  4. Is it possible to output a SELECT statement from a PL/SQL block?
  5. PL/SQL, how to escape single quote in a string?
  6. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  7. Passing an array of data as an input parameter to an Oracle procedure
  8. How to use BOOLEAN type in SELECT statement
  9. Get resultset from oracle stored procedure
  10. Oracle PL/SQL – How to create a simple array variable?
  11. ways to avoid global temp tables in oracle
  12. Split function in oracle to comma separated values with automatic sequence
  13. Number of rows affected by an UPDATE in PL/SQL
  14. PL/SQL print out ref cursor returned by a stored procedure
  15. Create Pivot view in SQL from a SQL table
  16. How to send email using Oracle 10 g Forms
  17. Why doesn’t PL/SQL respect privileges granted by Roles?
  18. Trigger to enforce M-M relationship
  19. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  20. Can We use threading in PL/SQL?
  21. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Why are Oracle table/column/index names limited to 30 characters?
  24. Functions vs procedures in Oracle
  25. What is the algorithm used by the ORA_HASH function?
  26. How to output result of SELECT statement which is executed using native dynamic SQL?
  27. passing in table name as plsql parameter
  28. Cursor For Loop with dynamic SQL-Statement
  29. How to use parameters in a ‘where value in…’ clause?
  30. No more data to read from socket

Leave a Comment