how to fix oracle ORA-01722 invalid number error

If you have a numeric column, all you have to do is use a to_char with the right parameters; this should do the work:

select to_char(column1, '00000000000000000D000000', 'NLS_NUMERIC_CHARACTERS = ''.,'''

Related Posts:

  1. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  2. Convert timestamp to date in Oracle SQL
  3. ORA-00904: invalid identifier
  4. ORA-00979 not a group by expression
  5. ORA-00907: missing right parenthesis
  6. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  7. ORA-01843 not a valid month- Comparing Dates
  8. SQL Error: ORA-00942 table or view does not exist
  9. ORA-00918: column ambiguously defined in SELECT *
  10. Oracle error : ORA-00905: Missing keyword
  11. How do I limit the number of rows returned by an Oracle query after ordering?
  12. Oracle SELECT TOP 10 records
  13. Can a foreign key be NULL and/or duplicate?
  14. How to Select Top 100 rows in Oracle?
  15. ORA-12560: TNS:protocol adaptor error
  16. ORA-00972 identifier is too long alias column name
  17. Oracle Apex column link from LOV values
  18. PLS-00103: Encountered the symbol when expecting one of the following:
  19. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  20. ORA-00918: column ambiguously defined in SELECT *
  21. ORA-00918: column ambiguously defined in SELECT *
  22. ORA-01861: literal does not match format string
  23. What is it exactly a BLOB in a DBMS context
  24. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  25. How do you create a temporary table in an Oracle database?
  26. Oracle “Partition By” Keyword
  27. How to insert date values into table
  28. Oracle SQL: Update a table with data from another table
  29. Oracle SQL query for Date format
  30. SQL selecting rows by most recent date with two unique columns
  31. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  32. Comparing Dates in Oracle SQL
  33. How do I reset a sequence in Oracle?
  34. Update statement with inner join on Oracle
  35. MySQL equivalent of DECODE function in Oracle
  36. Oracle: If Table Exists
  37. DATEDIFF function in Oracle
  38. How to create id with AUTO_INCREMENT on Oracle?
  39. LEFT function in Oracle
  40. What is the difference between Views and Materialized Views in Oracle?
  41. How do I view the Explain Plan in Oracle Sql developer?
  42. ORA-01779: cannot modify a column which maps to a non key-preserved table
  43. ORA-01735: invalid ALTER TABLE option – Toad
  44. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  45. Unknown column in ‘field list’ error on MySQL Update query
  46. When should I use CROSS APPLY over INNER JOIN?
  47. Insert Data Into Temp Table with Query
  48. SQL SELECT WHERE field contains words
  49. Using group by on multiple columns
  50. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  51. Inserting data into a temporary table
  52. CREATE VIEW must be the only statement in the batch
  53. SQL Server FOR EACH Loop
  54. How can I select the first day of a month in SQL?
  55. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  56. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  57. When to use “ON UPDATE CASCADE”
  58. MySQL combine two columns into one column
  59. SQL Error: ORA-00913: too many values
  60. SQL Server Insert if not exists
  61. SQL Server: Invalid Column Name
  62. Insert text with single quotes in PostgreSQL
  63. SQL Server IF NOT EXISTS Usage?
  64. String or binary data would be truncated. The statement has been terminated
  65. Error converting data type varchar to float
  66. How to concatenate text from multiple rows into a single text string in SQL Server
  67. Count(*) vs Count(1) – SQL Server
  68. Remove duplicate rows in MySQL
  69. how to remove time from datetime
  70. “You tried to execute a query that does not include the specified aggregate function”
  71. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  72. How to round down to nearest integer in MySQL?
  73. MySQL error: key specification without a key length
  74. SQL: Two select statements in one query
  75. Check if MySQL table exists without using “select from” syntax?
  76. mysql update column with value from another table
  77. ‘NOT LIKE’ in an SQL query
  78. SQL Server dynamic PIVOT query?
  79. What does Include() do in LINQ?
  80. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  81. Get everything after and before certain character in SQL Server
  82. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  83. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  84. ROW_NUMBER() in MySQ
  85. Foreign key references invalid table
  86. SQLite string contains other string query
  87. Varchar invalid for Sum operator
  88. SQL: How to properly check if a record exists
  89. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  90. SQL select of users by metadata
  91. WordPress SQL LIKE request doesn’t work for fields with special symbols
  92. Better way to migrate to server?
  93. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  94. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  95. Help me SELECT thumbnail from SQL and use
  96. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  97. Creating a “forum” – showing last post or last commented post
  98. Replace Unwanted Space in Post Content URL
  99. How to get the sum of each post with the same date
  100. Deleting the MySQL database

Leave a Comment