I firing query using 'concat' keyword with Oracle 11g but it's not working. can anyone help me?

Answer 1

Are you trying to concat two similar datatypes ? Check may be that's the problem. Ex for Oracle:
select CONCAT(col1, col2)