CONCAT

= =

CONCAT(//s1,s2//)
s1 is the first string, and s2 is the second string

Description-
When your concatenating, your SELECT statement needs two arguments. Concatenation means to put two strings (words) together. w hen concatenating, there must be two strings inorder for the function to work.

Examples:



SELECT CONCAT ('Oracle','Class') FROM dual
 * CONCAT ('Oracle','Class') ||
 * OracleClass ||

<span style="font-family: Georgia, serif;">
<span style="font-family: Georgia, serif;">SELECT CONCAT('Working','Hard') FROM employees
 * <span style="font-family: Georgia, serif;">CONCAT ('Working','Hard') ||
 * <span style="font-family: Georgia, serif;">WorkingHard ||

<span style="font-family: Georgia, serif;">
<span style="font-family: Georgia, serif;">SELECT CONCAT('Love', 'You') FROM dual
 * <span style="font-family: Georgia, serif;">CONCAT ('Love','You') ||
 * <span style="font-family: Georgia, serif;">LoveYou ||