SQL 错误“ORA

本文介绍了SQL 错误“ORA-01722:无效数字"的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

对某人来说非常简单，下面的插入给了我

A very easy one for someone, The following insert is giving me the

ORA-01722:无效号码

ORA-01722: invalid number

为什么?

INSERT INTO CUSTOMER VALUES (1,'MALADY','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES (2,'GIBSON','Jake','27 Smith St Caulfield','0415 713 598'); INSERT INTO CUSTOMER VALUES (3,'LUU','Barry','5 Jones St Malvern','0413 591 341'); INSERT INTO CUSTOMER VALUES (4,'JONES','Michael','7 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES (5,'MALADY','Betty','27 Smith St Knox','0418 418 347');

推荐答案

尝试将字符串转换为数字时出现 ORA-01722 错误，并且字符串无法转换为数字.

An ORA-01722 error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a number.

在没有看到您的表定义的情况下，您似乎正在尝试将值列表末尾的数字序列转换为数字，而分隔它的空格会引发此错误.但根据您提供给我们的信息，它可能发生在任何领域(第一个领域除外).

Without seeing your table definition, it looks like you're trying to convert the numeric sequence at the end of your values list to a number, and the spaces that delimit it are throwing this error. But based on the information you've given us, it could be happening on any field (other than the first one).