Home » SQL & PL/SQL » SQL & PL/SQL » Display avilable reco (Oracle 9i ,Windows)
Display avilable reco [message #320901] Fri, 16 May 2008 12:01 Go to next message
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
Member
Hi All,

i have source table as follows
ID	NAME	A	B	C	D	E
1	XYZ	0	1	2	0	0
2	ABC	1	1	0	1	1
3	XXX	0	0	0	0	1



i want to show out put as

ID	NAME	TYPE	ISEXIST
1	XYZ	B	1
1	XYZ	C	2
2	ABC	A	1
2	ABC	B	1
2	ABC	D	1
2	ABC	E	1
3	XXX	E	1




can any one help me out to solve this.

Thansks in Advance.. Smile
Re: Display avilable reco [message #320910 is a reply to message #320901] Fri, 16 May 2008 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Another "pivot" query with "row generator" (search for these).

Regards
Michel
Re: Display avilable reco [message #320913 is a reply to message #320910] Fri, 16 May 2008 13:12 Go to previous messageGo to next message
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
Member
Actually i searched on Pivot before i posted ,

It is solved,, Thanks for your support,,
Re: Display avilable reco [message #320921 is a reply to message #320913] Fri, 16 May 2008 13:46 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post the solution you found for future readers.

Regards
Michel
Previous Topic: alter session fails
Next Topic: How to execute a procedure out side of the package which is not defind in the package spec.
Goto Forum:
  


Current Time: Tue Dec 06 14:31:09 CST 2016

Total time taken to generate the page: 0.15100 seconds