How can you tell if a value is not numeric in Oracle?

by 
REGEXP_LIKE(column, '^[[:digit:]]+$')

returns TRUE if column holds only numeric characters

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. PL SQL UPDATE STATEMENT
  3. Splitting string into multiple rows in Oracle
  4. Search All Fields In All Tables For A Specific Value (Oracle)
  5. What is the string concatenation operator in Oracle?
  6. SQL recursive query on self referencing table (Oracle)
  7. create table with sequence.nextval in oracle [duplicate]
  8. IF EXISTS condition not working with PLSQL
  9. passing table and column name dynamically using bind variables
  10. SQL error “ORA-01722: invalid number”
  11. Is there any way to flush output from PL/SQL in Oracle?
  12. Sleep function in ORACLE
  13. Solution to “cannot perform a DML operation inside a query”?
  14. PLSQL Insert into with subquery and returning clause
  15. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  16. What does the colon sign “:” do in a SQL query?
  17. How to query a CLOB column in Oracle
  18. Oracle (Old?) Joins – A tool/script for conversion?
  19. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  20. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  21. Advice Using Pivot Table in Oracle
  22. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  23. Creating or simulating two dimensional arrays in PL/SQL
  24. How to handle optional parameters in SQL query?
  25. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  26. How to use Alias in Where clause? [duplicate]
  27. How to check if a column exists before adding it to an existing table in PL/SQL?
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. ORACLE After update trigger: solving ORA-04091 mutating table error
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment