hello all,
I need to concatinate 28||'-'||column1 where column1 is number datatype. The value after contination should appear 28-60 where 60 is the value present in column1.
How do I do that? 28 is static value.


select '28-'||column1 into temp from table1;--it didn't work

select to_number('28-')||column1 into temp from table1;--this didn't work either.

any help.