blocks|key|213555|text|当尝试将字符串转换为数字，但字符串无法转换为数字时，会发生ORA-01722错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|213556|在看不到您的表定义的情况下，您似乎正在尝试将值列表末尾的数字序列转换为数字，分隔它的空格将抛出此错误。但根据你给我们的信息，它可能发生在任何领域(除了第一个)。|213557|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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).

blocks|key|213568|text|假设电话号码定义为NUMBER，则不能将空格转换为号码：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|213569|create+table+telephone_number+(tel_number+number);
insert+into+telephone_number+values+('0419+853+694');|code-block|syntax|javascript|213570|以上代码为您提供了一个|213571|213572|+ORA-01722:无效的数字|blockquote|213573|213574|entityMap^0|9|6|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|W|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|X|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|Z|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|10|8|@]|D|@]|E|$]]|$1|R|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|S|$]]

Suppose telephone number is defined as <code>NUMBER</code> then the blanks cannot be converted into a number:

<pre><code>create table telephone_number (tel_number number);
insert into telephone_number values ('0419 853 694');
</code></pre>

The above gives you a 

<blockquote>
 ORA-01722: invalid number
</blockquote>

blocks|key|213576|text|有一种方法可以解决这个问题。删除非数字字符，然后将其转换为数字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|213577|cast(regexp_replace('0419+853+694',+'[%5E0-9]%2B',+'')+as+number)|code-block|syntax|javascript|213578|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's one way to solve it. Remove non-numeric characters then cast it as a number. 

<pre><code>cast(regexp_replace('0419 853 694', '[^0-9]+', '') as number)
</code></pre>

blocks|key|213208|text|它也可以是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|213209|SELECT+t.col1,+t.col2,+('test'+%2B+t.col3)+as+test_col3+
FROM+table+t;|code-block|syntax|javascript|213210|对于oracle中的串联，使用操作符%7C%7C而不是%2B。|offset|length|style|CODE|213211|在本例中，您将获得：ORA-01722:+invalid+number+...|213212|entityMap^0|0|0|I|2|N|1|0|A|T|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@$I|Y|J|Z|K|L]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|P|$]]

Well it also can be : 

<pre><code>SELECT t.col1, t.col2, ('test' + t.col3) as test_col3 
FROM table t;
</code></pre>

where for concatenation in oracle is used the operator <code>||</code> not <code>+</code>. 

In this case you get : <code>ORA-01722: invalid number ...</code>

blocks|key|2855882|text|当您尝试将非数字值插入到db中的数值列中时，出现此错误，似乎您的最后一个字段可能是数值，并且您正在尝试将其作为字符串发送到数据库中。检查您的上一个值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2855883|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As this error comes when you are trying to insert non-numeric value into a numeric column in db it seems that your last field might be numeric and you are trying to send it as a string in database. check your last value.

blocks|key|3069211|text|这是因为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3069212|3069213|您执行了一条SQL语句，试图将字符串转换为数字，但没有成功。|blockquote|3069214|3069215|3069216|如中所述：|3069217|3069218|Oracle/PLSQL:+ORA-01722+Error.|unordered-list-item|offset|length|3069219|3069220|要解决此错误，请执行以下操作：|3069221|3069222|算术运算中只能使用包含数值的数值字段或字符字段。确保所有表达式的计算结果都是数字。|3069223|3069224|entityMap|0|LINK|mutability|MUTABLE|url|http://www.techonthenet.com/oracle/errors/ora01722.php^0|0|0|0|0|0|0|0|0|U|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|19|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1B|8|@]|9|@$N|1C|O|1D|1|1E]]|A|$]]|$1|P|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1G|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|T|3|U|5|E|7|1I|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

This is because:

<blockquote>
 You executed an SQL statement that tried to convert a string to a
 number, but it was unsuccessful.
</blockquote>

As explained in:

<ul>
<li><a href="http://www.techonthenet.com/oracle/errors/ora01722.php" rel="noreferrer">Oracle/PLSQL: ORA-01722 Error.</a></li>
</ul>

To resolve this error:

<blockquote>
 Only numeric fields or character fields that contain numeric values
 can be used in arithmetic operations. Make sure that all expressions
 evaluate to numbers.
</blockquote>

blocks|key|215255|text|Oracle做自动的String2number转换，对于字符串列的值！但是，对于SQL中的文本比较，输入必须显式地分隔为字符串:相反的转换查询不会自动执行，也不会在SQL-+number2String级别上执行。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|215256|我有这样的疑问：|215257|215258|+select+max(acc_num)+from+ACCOUNTS+where+acc_num+between+1001000+and+1001999;|blockquote|CODE|215259|215260|215261|这就提出了一个问题：Error:+ORA-01722:+invalid+number|215262|我刚刚将的“数字”Strings值包围起来，使它们成为‘’，使它们成为显式分隔的|215263|215264|+select+max(acc_num)+from+ACCOUNTS+where+acc_num+between+'1001000'+and+'1001999';|215265|215266|215267|...and+voilà:它返回预期结果。|215268|编辑：和indeed:我的表中的列acc_num被定义为String。虽然不是数字，但报告了invalid+number。字符串号的显式定界解决了这个问题。|215269|另一方面，Oracle+可以将字符串视为数字。因此，可以对字符串应用数值操作/函数，并执行以下查询：|215270|215271|从表中选择max(string_column)；|215272|215273|select+string_column+from+TABLE+where+string_column+string_column+'2‘和'z'；|215274|从表中选择string_column，其中string_column+>+'1'；|215275|select+string_column+from+TABLE+where+string_column+<=+'b';|215276|entityMap^0|7|G|S|5|0|0|0|1|24|0|0|0|A|W|0|4|P|Z|5|0|0|1|28|0|0|0|0|0|3|1U|4|H|7|S|6|1A|E|0|C|2|0|0|5|3|0|0|1G|D|0|Z|1|0|1G|2|0^^$0|@$1|2|3|4|5|6|7|1F|8|@$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1K|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|1M|8|@$9|1N|A|1O|B|L]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1R|8|@$9|1S|A|1T|B|L]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1U|8|@$9|1V|A|1W|B|C]|$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|T|3|U|5|K|7|20|8|@$9|21|A|22|B|L]]|D|@]|E|$]]|$1|V|3|-4|5|6|7|23|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|24|8|@]|D|@]|E|$]]|$1|X|3|Y|5|6|7|25|8|@]|D|@]|E|$]]|$1|Z|3|10|5|6|7|26|8|@$9|27|A|28|B|C]|$9|29|A|2A|B|C]|$9|2B|A|2C|B|L]|$9|2D|A|2E|B|L]|$9|2F|A|2G|B|L]]|D|@]|E|$]]|$1|11|3|12|5|6|7|2H|8|@$9|2I|A|2J|B|C]]|D|@]|E|$]]|$1|13|3|-4|5|6|7|2K|8|@]|D|@]|E|$]]|$1|14|3|15|5|K|7|2L|8|@$9|2M|A|2N|B|C]]|D|@]|E|$]]|$1|16|3|-4|5|6|7|2O|8|@]|D|@]|E|$]]|$1|17|3|18|5|6|7|2P|8|@$9|2Q|A|2R|B|C]]|D|@]|E|$]]|$1|19|3|1A|5|6|7|2S|8|@$9|2T|A|2U|B|C]]|D|@]|E|$]]|$1|1B|3|1C|5|6|7|2V|8|@$9|2W|A|2X|B|C]]|D|@]|E|$]]|$1|1D|3|-4|5|6|7|2Y|8|@]|D|@]|E|$]]]|1E|$]]

Oracle does automatic String2number conversion, for String column values! However, for the textual comparisons in SQL, the input must be delimited as a String explicitly: The opposite conversion number2String is not performed automatically, not on the SQL-query level.
I had this query:
<blockquote>
<code>select max(acc_num) from ACCOUNTS where acc_num between 1001000 and 1001999;</code>
</blockquote>
That one presented a problem: <code>Error: ORA-01722: invalid number</code>
I have just surrounded the &quot;numerical&quot; values, to make them 'Strings', just making them explicitly delimited:
<blockquote>
<code>select max(acc_num) from ACCOUNTS where acc_num between '1001000' and '1001999';</code>
</blockquote>
...and voilà: It returns the expected result.
edit:
And indeed: the col <code>acc_num</code> in my table is defined as <code>String</code>. Although not numerical, the <code>invalid number</code> was reported. And the explicit delimiting of the string-numbers resolved the problem.
On the other hand, Oracle can treat Strings as numbers. So the numerical operations/functions can be applied on the Strings, and these queries work:
<blockquote>
select max(string_column) from TABLE;
select string_column from TABLE where string_column between '2' and 'z';
select string_column from TABLE where string_column &gt; '1';
select string_column from TABLE where string_column &lt;= 'b';
</blockquote>

blocks|key|213587|text|在我的例子中，转换错误出现在我为表创建的基于函数的索引中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|213588|插入的数据是正常的。我花了一段时间才弄清楚真正的错误来自于buggy索引。|213589|如果Oracle能够在这种情况下给出更准确的错误消息，那就更好了。|213590|entityMap^0|M|5|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|P|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|K|$]]

In my case the conversion error was in functional based index, that I had created for the table.

The data being inserted was OK. It took me a while to figure out that the actual error came from the buggy index. 

Would be nice, if Oracle could have gave more precise error message in this case.

blocks|key|210624|text|如果执行insert+into...select+*+from...语句，也很容易得到“Invalid+Number”错误。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|210625|假设您有一个名为FUND_ACCOUNT的表，它有两列：|210626|AID_YEAR++char(4)
OFFICE_ID+char(5)|code-block|syntax|javascript|210627|假设您希望将OFFICE_ID修改为数字，但是表中存在现有行，更糟糕的是，其中一些行的OFFICE_ID值为‘’(空白)。在Oracle中，如果表包含数据，则不能修改列的数据类型，并且需要一些技巧才能将‘’转换为0。下面是如何做到这一点的：|210628|创建一个复制表：CREATE+TABLE+FUND_ACCOUNT2+AS+SELECT+*+FROM+FUND_ACCOUNT;|210629|Delete原始表中的所有行：DELETE+FROM+FUND_ACCOUNT;|unordered-list-item|210630|
|210631|Once原始表中没有数据，请更改其OFFICE_ID列的数据类型：ALTER+TABLE+FUND_ACCOUNT+MODIFY+(OFFICE_ID++number);|210632|210633|But，然后是棘手的部分。因为有些行包含空的OFFICE_ID值，所以如果执行简单的INSERT+INTO+FUND_ACCOUNT+SELECT+*+FROM+FUND_ACCOUNT2，您将得到"ORA-01722+Invalid+Number“错误。为了将‘’(空白)+OFFICE_IDs转换为0，您的insert语句必须如下所示：|210634|210635|INSERT+INTO+FUND_ACCOUNT+(AID_YEAR,+OFFICE_ID)+SELECT+AID_YEAR,+decode(OFFICE_ID,'+',0,OFFICE_ID)+FROM+FUND_ACCOUNT2;|210636|entityMap^0|4|U|0|8|C|0|0|0|8|1L|0|F|P|0|0|X|1G|0|0|16|1G|0|0|0|39|0^^$0|@$1|2|3|4|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1B|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1C|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|S|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|T|3|U|5|6|7|1J|8|@]|D|@]|E|$]]|$1|V|3|W|5|S|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|X|3|U|5|6|7|1N|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|S|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|10|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]|$1|11|3|12|5|6|7|1S|8|@$9|1T|A|1U|B|C]]|D|@]|E|$]]|$1|13|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]]|14|$]]

If you do an <code>insert into...select * from...</code>statement, it's easy to get the 'Invalid Number' error as well. 

Let's say you have a table called <code>FUND_ACCOUNT</code> that has two columns:

<pre><code>AID_YEAR char(4)
OFFICE_ID char(5)
</code></pre>

And let's say that you want to modify the OFFICE_ID to be numeric, but that there are existing rows in the table, and even worse, some of those rows have an OFFICE_ID value of ' ' (blank). In Oracle, you can't modify the datatype of a column if the table has data, and it requires a little trickery to convert a ' ' to a 0. So here's how to do it:

<ol>
<li>Create a duplicate table: <code>CREATE TABLE FUND_ACCOUNT2 AS SELECT * FROM FUND_ACCOUNT;</code></li>
<li>Delete all the rows from the original table: <code>DELETE FROM FUND_ACCOUNT;</code></li>
<li>Once there's no data in the original table, alter the data type of its OFFICE_ID column: <code>ALTER TABLE FUND_ACCOUNT MODIFY (OFFICE_ID number);</code></li>
<li>But then here's the tricky part. Because some rows contain blank OFFICE_ID values, if you do a simple <code>INSERT INTO FUND_ACCOUNT SELECT * FROM FUND_ACCOUNT2</code>, you'll get the "ORA-01722 Invalid Number" error. In order to convert the ' ' (blank) OFFICE_IDs into 0's, your insert statement will have to look like this: </li>
</ol>

<code>INSERT INTO FUND_ACCOUNT (AID_YEAR, OFFICE_ID) SELECT AID_YEAR, decode(OFFICE_ID,' ',0,OFFICE_ID) FROM FUND_ACCOUNT2;</code>

blocks|key|210673|text|这也发生在我身上，但问题实际上是不同的：文件编码。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|210674|文件是正确的，但文件编码错误。它是由SQL+Server的导出实用程序生成的，我将其保存为Unicode。|210675|文件本身在文本编辑器中看起来不错，但是当我打开SQL*loader用被拒绝的行生成的*.bad文件时，我发现每个原始字符之间都有不好的字符。然后我想了想编码的问题。|CODE|210676|我用Notepad%2B%2B打开了原始文件，并将其转换为ANSI，一切都正常加载。|210677|entityMap^0|K|4|0|0|16|5|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|S|8|@$9|T|A|U|B|J]]|D|@]|E|$]]|$1|K|3|L|5|6|7|V|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|N|$]]

This happened to me too, but the problem was actually different: file encoding.

The file was correct, but the file encoding was wrong. It was generated by the export utility of SQL Server and I saved it as Unicode.

The file itself looked good in the text editor, but when I opened the <code>*.bad</code> file that the SQL*loader generated with the rejected lines, I saw it had bad characters between every original character. Then I though about the encoding.

I opened the original file with Notepad++ and converted it to ANSI, and everything loaded properly.

blocks|key|213197|text|ORA-01722错误非常简单。根据Tom+Kyte的说法|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|213198|213199|我们曾尝试显式或隐式将字符串转换为数字，但都失败了。|blockquote|213200|213201|213202|然而，问题在哪里往往一开始并不明显。This+page帮助我解决了问题，找到并解决了问题。提示:查找显式或隐式将字符串转换为数字的位置。(我的代码中有NVL(number_field,+'string')。)|style|CODE|213203|entityMap|0|LINK|mutability|MUTABLE|url|https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:45012348053|1|http://www.dba-oracle.com/sf_ora_01722_invalid_number.htm^0|I|8|0|0|0|0|0|0|23|R|I|9|1|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|-4|5|6|7|11|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|12|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|13|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|14|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|15|8|@$A|16|B|17|L|M]]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|N|3|-4|5|6|7|1B|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]|V|$5|Q|R|S|C|$T|W]]]]

The ORA-01722 error is pretty straightforward. According to <a href="https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:45012348053" rel="nofollow">Tom Kyte</a>:

<blockquote>
 We've attempted to either explicity or implicity convert a character string to a number and it is failing.
</blockquote>

However, where the problem is is often not apparent at first. <a href="http://www.dba-oracle.com/sf_ora_01722_invalid_number.htm" rel="nofollow">This page</a> helped me to troubleshoot, find, and fix my problem. Hint: look for places where you are explicitly or implicitly converting a string to a number. (I had <code>NVL(number_field, 'string')</code> in my code.)

blocks|key|2856040|text|当您遇到无效号码错误时，也可以尝试此操作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2856041|在这里，a.emplid是number，b.emplid是一个varchar2，所以如果你要转换其中一条边|2856042|其中to_char(a.emplid)=b.emplid|2856043|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

try this as well, when you have a invalid number error

In this 
a.emplid is number and b.emplid is an varchar2 so if you got to convert one of the sides 

where to_char(a.emplid)=b.emplid

blocks|key|210617|text|您可以始终使用TO_NUMBER()函数来删除此error.This可作为INSERT+INTO+employees+phone_number值(TO_NUMBER(‘0419+853+694')；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|210618|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can always use TO_NUMBER() function in order to remove this error.This can be included as INSERT INTO employees phone_number values(TO_NUMBER('0419 853 694');

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

<blockquote>
 ORA-01722: invalid number
</blockquote>

why?

<pre><code>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');
</code></pre>

SQL error "ORA-01722: invalid number"

对于某些人来说，这是一个非常简单的方法，下面的插入代码给了我 ORA-01722:数字无效为什么？INSERT INTO CUSTOMER VALUES (1,'MALADY','Claire','27 Smith St Caulfield','0419 853 694');INSERT INTO CUSTOMER VALUES (2,'GIBSON','Jake','27 Smith St Ca

问SQL错误"ORA-01722:无效数字“
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL错误"ORA-01722:无效数字“EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL错误"ORA-01722:无效数字“
EN