CODEWITHSUNDEEP
sqloracle-database
Elisabeth
Elisabeth

Reputation: 21206

What is the task of this oracle operator

CREATE OR REPLACE VIEW V_DIM_PrcProjectSppmse AS
SELECT
    'PROJECT' as Parent,
    'PRJCATE_' || ListItemId as Child,
    ...
        FROM
    MyVIEW

What does the this operator '||' above mean and how is it named?

Upvotes: 1

Views: 78

Answers (2)

Olivier Jacot-Descombes
Olivier Jacot-Descombes

Reputation: 112352

|| is string concatenation. In C# it would be + in VB &.

'aaa' || 'bbb' ==> 'aaabbb'

Upvotes: 4

Matt Fellows
Matt Fellows

Reputation: 6522

It's a concatenation operator - it appends the second value to the first. It's called a Concatenation operator.

In other languages you may see this as the plus symbol + or an ampersand &

In your example the value of ListItemId is appended to the string 'PRJCATE_'. e.g. if ListItemId had the value 15 you'd get 'PRJCATE_15' as the second column.

Upvotes: 1

Related Questions