Only numeric fields may be added to or subtracted from dates.Īction: Check the character strings in the function or expression. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions. ![]() ![]() Select count(1),trunc(droptime) from dba_recyclebin group by trunc(droptime) order by 1 descĬause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. SQL> select count(1),trunc(droptime) from dba_recyclebin group by trunc(droptime) order by 1 desc ![]() I got “ ORA-01722 invalid number ” error in Oracle SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |