<div>
really? &nbsp;that simple! &nbsp;<br />
<br />
Thanks!
</div>


<div>
What exactly you want to add?<br />
SELECT ColA + ColB FROM YourTableI<br />
f ColA and ColB are numaric, you will get the sum. If anyone of them is Alpha-Numaric, it will concatinate both columns. Do you want the numaric data also to be concatinated? like 10 and 20 to be as 1020<br />

</div>


What exactly you want to add?
SELECT ColA + ColB FROM YourTableI
f ColA and ColB are numaric, you will get the sum. If anyone of them is Alpha-Numaric, it will concatinate both columns. Do you want the numaric data also to be concatinated? like 10 and 20 to be as 1020


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Quick Q as I cant find much in books / google. If I wanted to add two columns together how would I do that in SQL?<br />
<br />
1 plus 1 = 2<br />
<br />
Where 1 is is column 1, &nbsp; the other 1 is column 2 and the answer &nbsp;is in the &quot;total&quot; column.<br />
<br />
If it is possible what would the syntax look like?<br />
<br />
Thanks!
</div>
</div>


Hi,

Quick Q as I cant find much in books / google. If I wanted to add two columns together how would I do that in SQL?

1 plus 1 = 2

Where 1 is is column 1,   the other 1 is column 2 and the answer  is in the "total" column.

If it is possible what would the syntax look like?

Thanks!

Is it possible to do addition in SQL

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.