Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as claimdata
SQL> SELECT 'AAA'||'_'||'BBB'||'CCC' as concat FROM dual;
CONCAT
----------
AAA_BBBCCC
SQL>
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as claimdata
SQL> SELECT 'AAA'||'_'||'BBB'||'CCC' as concat FROM dual;
CONCAT
----------
AAA_BBBCCC
SQL>