Category "oracle11g"

Oracle appending string to a select statement

I have a column in a oracle table Lic_num char(7 byte) SELECT column1, 'ABC' + Lic_num FROM TABLE One I wanted ABC appended to all the rows that are returned