Hi I have an oracle database with address and contact details on it. We recently did a change to one of the tables and to keep my data safe we did a csv extract. The data was re-imported when the other work had been done, unfortunately no one chedked the csv telephone field and we have managed to strip out the leading zero's from the telephone number. My sql is not good enough to write a script that will allow me to insert the leading zero without destroying the main body of the number. Can anyone help please?
the table name is unit and the field is called cellular_code