Your technology certification is waiting. Enroll in Cloud Class ®
Transact-SQL does not support this feature. See the + (Add) operator [MSDN-Add] for equivalent functionality to the concatenation operator (||) operator in [ISO/IEC9075-2:2011].
By 1986, ANSI and ISO standard groups officially adopted the standard "Database Language SQL" language definition. New versions of the standard were published in 1989, 1992, 1996, 1999, 2003, 2006, 2008, 2011, and most recently, 2016. 
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Slight correction: SQL in Oracle is called SQL. PL/SQL is Oracle's programming language and is pretty much Ada. Can PL/SQL contain SQL, yes. Can SQL contain PL/SQL, no.
c.AreaCode = '800',
c.Prefix = '555'
c.Suffix = '5000'
c.Company = 'ABC International'
Open in new window
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.