Text - Concatenation Function

Data System Architecture

About

This a string function which allows to concatenate two different strings.

Database

SQL Server - Transat-SQL

select year + '-' + week from DIM_WEEK
GO

Oracle SQL

select year || week from DIM_WEEK





Discover More
Model Funny
(Function|Operator) - Associative Property

An operator or functionop is associative if the following holds: The importance of this to parallel evaluation can be seen if we expand this to four terms: So we can evaluate (a op b) in parallel...
Model Funny
Function - Scalar

Scalar functions return a single value (as opposed to an array). Mathematics definition: Any function whose domain is a vector space and whose value is its scalar field. Is the result of a scalar function...
Data System Architecture
Number - Addition (or Sum, Sigma) or Total

The addition of all numbers in a set is called a total. Sum can be use as: an aggregate or a analytic function. It can follow the full syntax of the analytic function and in this way create It's...
Data System Architecture
Text - String

A string is a finite sequence of characters with the same coding representation (ie character set). As a sequence is, a string is also characterized as an abstract data structure case...



Share this page:
Follow us:
Task Runner