<div>
preparedstatement pstmt=conn.preparestatemen<wbr />t(&quot;update table set col1=? where col1=?&quot;)<br />
pstmt.setInt(1,3)<br />
pstmt.setInt(2,4)<br />

</div>


preparedstatement pstmt=conn.preparestatement("update table set col1=? where col1=?")
pstmt.setInt(1,3)
pstmt.setInt(2,4)


<div>
I guess its with the <br />
update Table set col1=3, col2 = 99, col3=98 where col1 = 4<br />

</div>


I guess its with the
update Table set col1=3, col2 = 99, col3=98 where col1 = 4


<div>
&gt; update Table set col1=3, col2 = 99, col3=98 where col1 = 4<br />
<br />
correct :)<br />
<br />

</div>


> update Table set col1=3, col2 = 99, col3=98 where col1 = 4

correct :)



<div>
have a read here<br />
<br />
<a href="http://www.w3schools.com/sql/default.asp" rel="ugc">http://www.w3schools.com/sql/default.asp</a><br />

</div>


have a read here

http://www.w3schools.com/sql/default.asp [http://www.w3schools.com/sql/default.asp]


<div>
Sorry gibu_george <br />
thats not what i wanted, i asked for multiple columns <br />
i just posted the solution on top<br />

</div>


Sorry gibu_george
thats not what i wanted, i asked for multiple columns
i just posted the solution on top


<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
Can some one give me a sample syntax on how to update multiple columns.<br />
<br />
What I know:<br />
update Table set col1=3 where col1 = 4<br />

</div>
</div>


Dear Experts

Can some one give me a sample syntax on how to update multiple columns.

What I know:
update Table set col1=3 where col1 = 4


How to update multiple columns in a prepared statement

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

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.