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.
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] |
|
|
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 |
|
|
|
|
|