How to update a table having a column name as amount in number data type to comma separated digits followingenter image description here Indian Numbering System
I tried this code block
UPDATE sep
SET amount = TO_CHAR(amount, ‘999,999,999’)
and got the error like
Error report –
SQL Error: ORA-01722: invalid number
01722. 00000 – “invalid number”
*Cause: The specified number was invalid.
*Action: Specify a valid number.
I am expecting my table should look while updating exactly like the above image
New contributor
Vishrutha Dhanesh Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.