Re: 'Merging' Columns?
Alex,
CONCAT(col1,'#',col2)
would do this.
You can probably do this in just one sql statement. It will probably perform better too. Could you just paste the structure of your tables, and describe exactly what source columns need to be concatenated, and what the destination column is?
preferably post some (2, 3) rows of data of the "before" situation, and the desired "after" situation as well.
Thank you!
Subject
Written By
Posted
Re: 'Merging' Columns?
August 16, 2005 08:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.