-
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.
-
Code:
SQL> select 'abc' || chr(10) || 'def' from dual;
'ABC'||
-------
abc
def
SQL>
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Hi,
Thanks a lot !!!
Take Care.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|