Good Morning All,
I'm looking for some help on updating values in a table. I need to insert/add a space in between the value, preferably after the 3rd character in the string. I've not been able to achieve this or find any good way to do so.
So, for example. I have a value that looks like this '45DGDTD333', and now i need it to look at like, '45D GDTD333'.
Ive run the following query like so: select substr('45DGDTD333',1,3)) from dual; to make sure I am at the right spot to insert the space, but just can't figure out how to insert the space into the values and update the data in the table.
Any help will be much appreciated. Thanks in advance.