Oracle SQL Code

SeTech
SeTech used Ask the Experts™
on
I generally use Microsoft SQL, however I have recently had to access and Oracle Server and have been given some code to run. The code contains many || ( two vertical parallel lines). Can someone please educate me on their meaning/usage? Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
in short it's joining the chars
johnsoneSenior Oracle DBA

Commented:
That is a string concatenation operator.

The documentation is your friend -> http://docs.oracle.com/cd/E11882_01/server.112/e41084/operators003.htm#SQLRF51158

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial