I'm new to Oracle SQL and I need your help please...
I have a table called clients and there is a column called pictures..
I need to update the pictures from ".png" to ".jpg" is that possible?
I looked in the internet a little bit and I found this command (translate( string1, string_to_replace, replacement_string )).
Can I use it within a command ?
update pictures from clients where pictures = translate( string1, string_to_replace, replacement_string );
Is that possible ??!