Home » SQL & PL/SQL » SQL & PL/SQL » sql (oracle db 10g)
sql [message #413251] Wed, 15 July 2009 00:42 Go to next message
vdsk
Messages: 41
Registered: February 2006
Location: India & UAE
Member
From the emp table (scott/tiger) as listed below,
empno ename job hiredate
1000 JOAN MANAGER 1-JAN-07
2000 SAM DEVELOPER 2-MAY-06

I need the query output with rows & cols switched like :-

empno 1000
ename JOAN
job MANAGER
hiredate 1-JAN-07

empno 2000
ename SAM
job DEVELOPER
hiredate 2-MAY-06


Please let me know how to write the query or is there any
sql function/command available for this ?

Re: sql [message #413253 is a reply to message #413251] Wed, 15 July 2009 00:48 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
http://asktom.oracle.com/tkyte/print_table/
Previous Topic: Calculating Average Days (merged)
Next Topic: Getting Error with Cross join query
Goto Forum:
  


Current Time: Fri Dec 02 18:30:13 CST 2016

Total time taken to generate the page: 0.42625 seconds