<div>
<pre><code id="code-20-40708572-1">update table
set column = replace(column,'\\folder1\folder2\folder3\','\\folder4\folder5\folder6\')
where key = &lt; value&gt;;</code></pre>
</div>


update table
set column = replace(column,'\\folder1\folder2\folder3\','\\folder4\folder5\folder6\')
where key = < value>;

<div>
You could also accomplish the above without the replace function -<br />
update yourtable<br />
set path = &nbsp;'\\folder4\folder5\folder6<wbr />'||substr(<wbr />path,instr<wbr />(path,'\',<wbr />-1))<br />
where path like '\\folder1\folder2\folder3<wbr />\%';<br />
<br />
However, since you mention two columns, are you trying to replace the path in one column with the path from another column? If so, could you provide some sample data for both columns and your expected output?
</div>


You could also accomplish the above without the replace function -
update yourtable
set path =  '\\folder4\folder5\folder6'||substr(path,instr(path,'\',-1))
where path like '\\folder1\folder2\folder3\%';

However, since you mention two columns, are you trying to replace the path in one column with the path from another column? If so, could you provide some sample data for both columns and your expected output?

<div>
<div class="content wysiwyg-content">
Hello Experts:<br />
<br />
I two columns in ORA table with NAS path i.e. <br />
<br />

<pre><code id="code-10-28650721-1">\\folder1\folder2\folder3\some file name1.doc
\\folder1\folder2\folder3\some file name2.doc
\\folder1\folder2\folder3\some file name3.doc
\\folder1\folder2\folder3\some file name4.doc</code></pre>
<br />
I would like to replace it with new NAS path \\folder4\folder5\folder6\<wbr /><br />
<br />
output like this<br />
<br />

<pre><code id="code-10-28650721-2"> \\folder4\folder5\folder6\some file name1.doc
 \\folder4\folder5\folder6\some file name2.doc
 \\folder4\folder5\folder6\some file name3.doc
 \\folder4\folder5\folder6\some file name4.doc</code></pre>
<br />
Can somebody please assist with this update query?<br />
<br />
Regards,<br />
CS
</div>
</div>


Hello Experts:

I two columns in ORA table with NAS path i.e. 

(CODE)

I would like to replace it with new NAS path \\folder4\folder5\folder6\

output like this

(CODE)

Can somebody please assist with this update query?

Regards,
CS

replace function in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.