Home -> Usenet -> comp.databases.oracle -> dynamic view

dynamic view

From: ck <reachgopi_at_yahoo.com>
Date: 7 Dec 2002 16:31:36 -0800
Message-ID: <ef13ca67.0212071631.1c19f629_at_posting.google.com> 






I am new oracle programming and I  want to create a dynamic view ,
which is a combination of  following tables –



Project Table


Project	  F code
DSAA	  0012
DSAB	  0013
DSAC	  0013





Activity Table


Activity	Activity Value
1000TA	             12
2000TA	             13
3000TA               14





Activity Def Table


Owner	Activity name
DS	    ASD
DS	    AFD
DS	    PFD
DO	    ASD
DO	    AFD
DO	    PFD
Right now this table has 51 records. In future there chance it might


increase to infinite number of rows. Each row I  this Table has
related value in the Activity Table. I want dynamic code in the View
so that when ever this table is updated it should reflect in the
results.





This how the Result should look like- 


Project	Activity ASD AFD PFD Activity ASD AFD PFD
DSAA	1000TA	 12  12  12   2000TA  13  13  13
DSAB	1000TA	 12  12  12   2000TA  13  13  13	


I want the values to be displayed as a cross tab. The rows in the
Activity Def and Activity Tables should be displayed as columns in the
Result. Each Activity Name in the Activity Table will have a record in
the Activity Table.




Thank You Very Much,


ck
Received on Sun Dec 08 2002 - 01:31:36 CET












Original text of this message