Hope you're doing well. I have a table with this structure :
Table1(Cust_No Varchar2(50), First_Name Varchar2(50), Last_Name Varchar2(50), Error_Code number(1), Error_Desc Varchar2(50))
At first , data will be inserted into column
Cust_No and I should
Update other columns of the table based on this column.The point is that all
cust_No must have number format. For example
Cust_No ='aa674' does not have a correct format.
I need to write a query to
update the table and set
First_Name='--' , column
Last_Name = '--',
Error_Code=1 and column
for those Cust_No which has incorrect formats.
I wanted to use
TO_NUMBER() function but it gives me invalid number error.
how may I solve this problem?
Thanks in advance