<div>
update yourtable<br />
set yourcolumn = concat ( youcolumn , '&quot;' )<br />
where substr ( yourcolumn , length( yourcolumn) 1 ) &lt;&gt;&nbsp;'&quot;' <br />

</div>


update yourtable
set yourcolumn = concat ( youcolumn , '"' )
where substr ( yourcolumn , length( yourcolumn) 1 ) <> '"'


<div>
Thx @ both of you. I used the solution of geotiger but johnsone gave me an exact answer for my question. But i din't have to commit every row. I did it only once. But I'm sure johnsone's way would work too...<br />
<br />
Greets and best Regards,<br />
Andy
</div>


Thx @ both of you. I used the solution of geotiger but johnsone gave me an exact answer for my question. But i din't have to commit every row. I did it only once. But I'm sure johnsone's way would work too...

Greets and best Regards,
Andy

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need a sciprt for oracle to update a column. The single entry only should updated if a condition is met.<br />
<br />
A little bit more detailed:<br />
If the last char is a &quot;, the script should do nothing. If not &quot;&nbsp;is the last char, it should add a &quot;&nbsp;at the end of the text string. Then commit the changes and go to the next entry...<br />
<br />
It would be nice if anybody can help me :)<br />
<br />
Greets and best regards,<br />
Andy<br />
<br />
<br />

</div>
</div>


Hi,

I need a sciprt for oracle to update a column. The single entry only should updated if a condition is met.

A little bit more detailed:
If the last char is a ", the script should do nothing. If not " is the last char, it should add a " at the end of the text string. Then commit the changes and go to the next entry...

It would be nice if anybody can help me :)

Greets and best regards,
Andy




script to update row with condition

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.