Hi,
I want to write sql to get output for some of the row as column?
Some of the information is repeating except name so i want to make name as row but i don't know the value of name as it will come through web dynamically. IF i know the value then i know to use as i have pasted at bottom.
==============
[B]Output will be[/B]
==============
A.id 	B.id 	D.fname	d.lname	c.name
1	b1	pora	Sch	ACT1
1	b1	pora	Sch	ACT2

simple query with join like:

SELECT b.id, d.fname, d.lname, c.name  
FROM tab1 a,  tab_info b, tab3 c, tab_user d  
WHERE a.id = b.id 
  and a.id = d.id  
==================
MAX(DECODE(type, 'X' ,value, '')) "X",
MAX(DECODE(type, 'Y' ,value, '')) "Y",
But I can't use this as i don't know the value.

Thanks,

Thanks, Sorry about it.
I have ORacle 9i R2.

From this kind of normal output, i want to make records like:

A.id 	B.id 	D.fname	d.lname	c.name
1	b1	pora	Sch	ACT1
1	b1	pora	Sch	ACT2


Final results
==============
A.id 	B.id 	D.fname	d.lname	c.name_ACT1 	c.name_ACT2 (This name column value will be dynamic)
1	b1	pora	Sch	    Yes (or 1)	  Yes (or 0 if not that vlaue)

Thanks in advance.