dynamic sql

[reachgopi]

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

Project Table

Proj Fcode
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 in this Table has a 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-

Proj 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 table and Activity from the Activity table 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,
gopi

 

[Bimalaggarwal]

Your query in not clear, especially the relationships.
Please explain the relation of each column in the resultset and the tables which you have mentioned above.