| How to display the result horizontally [message #576947] |
Mon, 11 February 2013 04:36  |
 |
balakrishnaallu
Messages: 5
Registered: December 2010
Location: Hyderabad
|
Junior Member |
|
|
1.Requirement....
deptno ename
++++++++++++++++++++++++++++++
10 a,d,e,g
20 b,c,j
30 k,l,o
Please give me replay ASAP.
2.How to swap the column values ? ex. col2 into col1 and col1 into col2
3.What is the major Diff. b/w Right outer join & Left outer join ?
[EDITED by LF: fixed topic title typo; was "horizantally"]
[Updated on: Mon, 11 February 2013 10:40] by Moderator Report message to a moderator |
|
|
|
| Re: How to display the result horizantally [message #576948 is a reply to message #576947] |
Mon, 11 February 2013 04:40  |
 |
Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
From your previous posts:
Michel Cadot wrote on Fri, 25 February 2011 15:58...
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
...
Michel Cadot wrote on Fri, 25 February 2011 17:22...
Once again:
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
...
BlackSwan wrote on Sun, 27 February 2011 15:59It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Michel Cadot wrote on Sun, 27 February 2011 19:21Please read OraFAQ Forum Guide and do not post in UPPER case.
...
I add:
With any SQL or PL/SQL question, please, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
And FEEDBACK to those that help you.
Regards
Michel
|
|
|
|
| Re: How to display the result horizantally [message #576952 is a reply to message #576948] |
Mon, 11 February 2013 05:34 |
 |
rishwinger
Messages: 101
Registered: November 2011
|
Senior Member |
|
|
SQL> select deptno,wm_concat(ename) from emp group by deptno;
DEPTNO WM_CONCAT(ENAME)
----------------- --------------------
10 CLARK,KING,MILLER
20 SMITH,FORD,ADAMS,SCOTT,JONES
30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
