| Author |
 Topic  |
|
|
waelt
Starting Member
Syria
2 Posts |
 Posted - 05/15/2011 : 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 |
Edited by - waelt on 05/15/2011 11:10:11
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 05/15/2011 : 11:32:01
|
SQLTeam is on Microsoft SQL Server, for Oracle question, try dbforums.com
KH
Time is always against us
|
 |
|
|
waelt
Starting Member
Syria
2 Posts |
Posted - 05/15/2011 : 12:39:14
|
quote:
Originally posted by khtan
SQLTeam is on Microsoft SQL Server, for Oracle question, try dbforums.com
KH
Time is always against us
oops 
Sorry for that misunderstanding  |
|
|
| |
Topic |
|
|
|
Replacing File extenstion
