Home » SQL & PL/SQL » SQL & PL/SQL » Column to Row (10g)
Column to Row [message #389931] Wed, 04 March 2009 03:26 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
Hi Gurus,

need a help.

I have data for a row in this formar

EMPNO,ENAME,JOB,MGR
7499,ALLEN,SALESMAN,7698

I want to display as
Emp No,
ename
job,
MGR

ie
7499,
ALLEN,
SALESMAN,
7698

Any one suggest what is best way to do ...

Re: Column to Row [message #389934 is a reply to message #389931] Wed, 04 March 2009 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best is to FIRST search as requested in OraFAQ Forum Guide.
And read "How to format your post?" section adn use code tags.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: Column to Row [message #389937 is a reply to message #389931] Wed, 04 March 2009 03:59 Go to previous message
Serious Sam
Messages: 21
Registered: September 2007
Junior Member
If you could type your subject in the search column, you would have got this link.

http://www.orafaq.com/forum/m/383791/112016/#msg_383791
Previous Topic: procedure in out
Next Topic: ORA-01031: insufficient privileges
Goto Forum:
  


Current Time: Thu Dec 08 00:29:01 CST 2016

Total time taken to generate the page: 0.23200 seconds