Answered before

[tanaka]

Hi ,

This question was answered befor but I am unable to find it...

I have 2 address columns and i want to display them one below the other.

Eg:

Address1 Address2
21,Shinjuku, Tokyo,Japan.

Result desired :

Address
21,Shinjuku,
Tokyo,Japan.

I remember that it could be done using char() but not sure.

Thanks.

[jmodic]

SQL> select 'abc' || chr(10) || 'def' from dual;

'ABC'||
-------
abc
def

SQL>

[tanaka]

Hi,

Thanks a lot !!!

Take Care.