Concatenation In Oracle Sql. If you want to concatenate more values than two, you can. Concat returns char1 concatenated with char2.both char1 and char2 can be any of the datatypes char, varchar2, nchar, nvarchar2, clob, or nclob.the string returned is in the same character set as char1.its datatype depends on the datatypes of the arguments.

In concatenations of two different data types, oracle database returns the data type that results. We can also use a literal. The most common usuage you popularly find on internet is to convert multiple rows to a single row with a delimiter.