Numeric Value Expressions
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a numeric value.
Syntax
|
| | |
<term> <numeric value expression> + <term> <numeric value expression> - <term> |
<factor> ::= [ { + | - } ] <numeric primary>
Notes
| ♦ | The declared type of a numeric primary shall be a numeric type. |
| ♦ | If both operands are exact numeric types, then the data type of the result is an exact numeric type with precision not less than the maximum precision of the two operands and the scale determined as follows: |
| ♦ | If addition or subtraction is specified, then the scale is the maximum of the two operands. |
| ♦ | If multiplication is specified, then the scale is the sum of the two operand scales, limited by the maximum scale of 4. |
| ♦ | If division is specified, then the scale is the maximum scale 4. |
| ♦ | If either of the operands are an approximate numeric type, then the result is an approximate numeric type with precision not less than the maximum precision of the two operands. |
| ♦ | Normal operator precedence is applied. |
See also: Numeric Value Functions
Examples
| 1) | The following example raises all teacher salaries by a given percent: |
UPDATE teachers
SET salary = salary * ( 1 + ( :percent / 100 ) )
| 2) | Some examples of valid numeric value expressions: |
| ♦ | -5 |
§ 3 + 1
§ 7/3-16
§ 15 * ( 5-4 )
Conformance
|
SQL:2003 standard |
- |
Core SQL |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
![[]](/support/modules/ubercart/uc_cart/images/bullet-arrow-up.gif "Expand cart block."){kind=icon}
| 1x | NexusDB AWE DLL (1 installation; binary) | AUD 330.00 |
| 1x | NexusDB Developer DCU Edition | AUD 600.00 |
| 1x | The Full Monty Pack | AUD 1,800.00 |
| 1x | NexusDB Professional Edition | AUD 1,400.00 |
| 1x | Memory Manager V4 | AUD 360.00 |
| 1x | NexusDB AWE DLL (site license; binary) | AUD 2,300.00 |
| 1x | NexusDB Embedded Source | AUD 430.00 |
| 1x | NexusDB PHP Connector | AUD 500.00 |
| 1x | NexusDB Server License Plugin | AUD 250.00 |
| 1x | NexusDB Starter Edition DCU | AUD 150.00 |
| 1x | NexusDB Developer Source Edition | AUD 890.00 |
| 4x | SLA - Silver (add years in quantity field) | AUD 4,000.00 |
| 1x | NexusDB AWE DLL (10 installations; binary) | AUD 1,950.00 |
| 4x | SLA - Gold (add years in quantity field) | AUD 10,666.68 |
| 1x | Visual Studio Standard Pack | AUD 500.00 |
| 1x | NexusDB AWE DLL (40 installations; binary) | AUD 6,400.00 |
| 1x | Nexus Quality Suite v1 | AUD 550.00 |
| 1x | SLA - Platinum (add years in quantity field) | AUD 5,300.00 |
| 24 Items | Total: AUD 38,376.68 |
| (View cart) (Checkout) | |
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm