Easy question from MS SQL to ORACLE

[antonopn]

Hello there,

I have this sql code that runs properly on sql server

select code+','+ name +','+afm+','+street1+','+zipcode1+','+phone11 from customer

How can I transform it to run in an oracle database?
Lets suppose the tables and columns are the same!

Thnaks!

[amitpatel66]

Replace a + sign with a || (double pipe) to run it in oracle

[antonopn]

thanks for the immediate answer!
I'm trying to use replicate function but it has errors.

This is the sql server code!

select replicate(code, 1)+','+replicate(name, 1)+','+replicate(afm, 1)+','+replicate(street1, 1)+','+replicate(zipcode1, 1)+','+replicate(phone11, 1) from customer

[amitpatel66]

thanks for the immediate answer!
I'm trying to use replicate function but it has errors.

This is the sql server code!

select replicate(code, 1)+','+replicate(name, 1)+','+replicate(afm, 1)+','+replicate(street1, 1)+','+replicate(zipcode1, 1)+','+replicate(phone11, 1) from customer

First you need to change the + sign to ||. Like this:

[code=oracle]

select code||','||name ||','||afm||',' ||street1||','| |zipcode1||','| |phone11 from customer

[/code]

[antonopn]

It Works Fine!

Thanks A Lot!!!!!!