-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|