Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Replacing File extenstion

Author  Topic 

waelt
Starting Member

2 Posts

Posted - 2011-05-15 : 11:06:23
Greetings,
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 ?
Like..
update pictures from clients where pictures = translate( string1, string_to_replace, replacement_string );
Is that possible ??!

Thanks a lot

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-05-15 : 11:32:01
SQLTeam is on Microsoft SQL Server, for Oracle question, try dbforums.com


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

waelt
Starting Member

2 Posts

Posted - 2011-05-15 : 12:39:14
quote:
Originally posted by khtan

SQLTeam is on Microsoft SQL Server, for Oracle question, try dbforums.com


KH
[spoiler]Time is always against us[/spoiler]





oops
Sorry for that misunderstanding
Go to Top of Page
   

- Advertisement -