This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
plus [2015/09/23 20:27] 127.0.0.1 external edit |
plus [2016/03/22 16:03] (current) dmtolpeko [Add Two Integers] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Addition Operator (+) - PL/HQL ====== | + | ====== Addition Operator (+) ====== |
- | You can use + arithmetic operator to add two numbers, or add an interval to a DATE value. | + | You can use + arithmetic operator to add two numbers, concatenate two strings, or add an interval to a DATE value. |
**Syntax:** | **Syntax:** | ||
Line 18: | Line 18: | ||
| 3 + 1 | 4 | Integer | | | 3 + 1 | 4 | Integer | | ||
+ | ===== Concatenate Two Strings ===== | ||
+ | |||
+ | When you use + for string operand the result of the operation is the concatenated string. | ||
+ | |||
+ | **Example:** | ||
+ | |||
+ | | **Expression** | **Result** | **Result Type** | | ||
+ | | 'Ab' + 'c' | 'Abc' | String | | ||
===== Add an Integer to Date ===== | ===== Add an Integer to Date ===== | ||