Value Expressions
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a scalar value.
Syntax
|
| | | | | | | |
<unsigned value specification> column-reference |
|
| | | | | | | | | |
SQL-parameter-reference SQL-variable-reference |
|
| | | |
SQL-parameter-reference SQL-variable-reference column-reference |
Usage
Value expressions return values with a data type declared by the expression, and can be used in SQL everywhere a value is expected and the particular data type is permitted. Value expressions can be as simple as a literal or a column reference, or complex expressions involving arithmetic operations, combined boolean logic, scalar subqueries, case expressions and SQL functions.
Conformance
|
SQL:2003 standard |
- - - - |
Core SQL Feature F052 "Intervals and datetime arithmetic" Feature T031 "BOOLEAN data type" Feature F471 "Scalar subquery values" |
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.
Site Updates
- Jul 24 2024 - 1:53pm
- Jul 24 2024 - 1:22pm
- Apr 10 2024 - 10:19am
- Jan 28 2024 - 7:30pm
- Jan 25 2024 - 9:10am