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.
Result desired :
I remember that it could be done using char() but not sure.
SQL> select 'abc' || chr(10) || 'def' from dual;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Thanks a lot !!!
Click Here to Expand Forum to Full Width