How to concat two column with '-' seperator in PL/SQL

Question

I just want to concat two columns with seperator '-'.

These are the two columns, want to concat.

I am using this query to concat them

select concat(amt,endamt)as amount from mstcatrule

and it is giving me result this

But I Want that data of 2 columns should be sepearted by '-'

RESULT I WANT IS :

AMOUNT
0-0
100-99999999999
100-500

Pragmatics

Answer 1

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.

Valladares

Answer 2

Alternative:

select amt || '-' || endamt as amount from mstcatrule;

Villeneuve

Can I use an underscore as delimiter? Doesn't seem to work for me. – Pinup

Answer 3

In oracle this works for me! :D

select amt||'-'||endamt as amount from mstcatrule

Selfevident

Answer 4

Another way is to use double pipe.

select amt || '-' || endamt as amount from mstcatrule;

You may have to convert amt and endamt to varchar

Blueberry

Answer 5

Alternative you can use under query

select concat(amt,'-',endamt) as amount from mstcatrule;

Eggcup

You can use ||'-'|| between two coloumn. – Eggcup

docs.oracle.com/cd/B28359_01/server.111/b28286/… – Eggcup

Answer 6

A generic format for the query

Select concat(column1,'-',column2) as concatedCols from table_Name

For Postgresql only

Arturoartus

How is this Answer different from the answer by Md. Nasir Uddin? Since the Question is tagged pl/sql I'm assuming this should run on an Oracle database, but the Oracle documentation does not allow for 3 parameters to CONCAT, and trying this result in the error: ORA-00909: invalid number of arguments – Guildhall