How to concat two column with '-' seperator in PL/SQL
Alternative:
select amt || '-' || endamt as amount from mstcatrule;
Do it with two concats:
select concat(concat(amt, '-'), endamt) as amount from mstcatrule;
concat(amt,'-')
concatenates the amt
with the dash and the resulting string is concatenated with endamt
.