Finding rows that don’t contain numeric data in Oracle

by

I was thinking you could use a regexp_like condition and use the regular expression to find any non-numerics. I hope this might help?!

SELECT * FROM table_with_column_to_search WHERE REGEXP_LIKE(varchar_col_with_non_numerics, '[^0-9]+');

More Related Contents:

  1. What is the major difference between Varchar2 and char
  2. Difference between BYTE and CHAR in column datatypes
  3. SQL Query output in VBA is different than in SQL Oracle
  4. I want to find out how much zero come after 1 in SQL
  5. Splitting string into multiple rows in Oracle
  6. GROUP BY with MAX(DATE) [duplicate]
  7. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  8. Can a foreign key be NULL and/or duplicate?
  9. Stored Procedure with optional “WHERE” parameters
  10. subquery in FROM must have an alias
  11. SQL multiple columns in IN clause
  12. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  13. How can I select from list of values in Oracle
  14. Selecting the second row of a table using rownum
  15. sqlplus statement from command line
  16. How to debug ORA-01775: looping chain of synonyms?
  17. Does Oracle store trailing zeroes for Number data type?
  18. Oracle Update Query using Join
  19. Generating dates between two dates
  20. How to convert Rows to Columns in Oracle? [duplicate]
  21. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  22. SQL not a single-group group function
  23. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  24. SQL Keep getting error with ON UPDATE CASCADE
  25. Oracle query to match all values in the list among all rows in table
  26. adding primary key to sql view
  27. How do I call an Oracle stored procedure from an Excel VBA script?
  28. How can I solve ORA-00911: invalid character error?
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment