hi guys
I wish to concatenate 2 columns of numeric type.. How can it be done..
Earlier i tried using the to_char function but it seems to be crashing
the backend. Any other option will be greatly appreciated..
select to_char(length,'9999D99') || to_char(breadth,'9999D99') from exhibit_distributions
This query seems to be crashing the backend when executed over the
table.. However when constrained using a appropriate where clause it
works..
Any other approach??.
Thanx
Anand