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 with lic_num appended to it.
I tried tha above query and it is not working.
In Oracle it's:
SELECT column1, 'ABC' || Lic_num
FROM TABLE_ONE
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With