Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

StringString

This function concatenates two strings. The general format for this function is: String||String SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual; 'THIS'||'IS'||'A'||'CON ----------------------- This is a concatenation SQL>