Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle [21.09.2017 @ 09:01]
Christophe Frattino [Replace a string in a column]
oracle [21.09.2017 @ 09:02] (current)
Christophe Frattino [Replace a string in a column (from --> to)]
Line 14: Line 14:
 ==== Replace a string in a column ("​from"​ --> "​to"​) ==== ==== Replace a string in a column ("​from"​ --> "​to"​) ====
 <code sql> <code sql>
-UPDATE ZDMS_RECORDS(path) VALUES (REPLACE(path,​ '​from',​ '​to'​)) WHERE path like '​%from%'​;+UPDATE ZDMS_RECORDS ​SET path=REPLACE(path,​ '​from',​ '​to'​);​
 </​code>​ </​code>​
 ===== Tools ===== ===== Tools =====
 To monitor the requests made from C# code : EFProfiler or [[https://​www.devart.com/​dbmonitor/​|DBMonitor]]. To monitor the requests made from C# code : EFProfiler or [[https://​www.devart.com/​dbmonitor/​|DBMonitor]].
Print/export