Hello,
How to convert a character string into a number in Oracle as I am getting the below ORA-01722: invalid number when I ran the below Update query?
SQL> UPDATE proddta.f1521 SET
NBURAT = NBDL01
WHERE
NBLGCL = 'LR'
2 3 4 5 ;
NBURAT = NBDL01
*
ERROR at line 2:
ORA-01722: invalid number