Oracle CONCAT

Is there a way to concatenate ore than two strings together using an ORACLE CONCAT statement. I don't want to have to resort to the following:-

Code:

---

CONCAT(CONCAT('A','B'),'C')

---

....as I've got four rows from a table that I need to concat together....
Is there another way? I am unable to use a function as the DB techincaly belongs to another company and we're not allowed to add/alter the schema.

Basically, the table I'm interested in contains addresses, the columns are ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4 and POSTCODE. I want to concat these using commas to separate them.

TIA

use the double pipe :

Code:

---

table.field || table.field2 || table.field3

---

I though concat used more that two parts?

Code:

---

concat(table.field,table.field2,table.field3)

---

Might be wrong on that.

Post up if neither work

I just spent a little time in my SQL Server book, and couldn't find CONCAT

Is that Oracle specific?

If so, is there an SQL Server equivalent?

http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html

Under String Functions.

Quote:

---

Originally Posted by SeanK

I just spent a little time in my SQL Server book, and couldn't find CONCAT

Is that Oracle specific?

If so, is there an SQL Server equivalent?

---

Yeah it is... but if its SQL Server you want.. use +