get data dynamically in sql

[Rakesh Keerthi]

Hi,
In the below SQL I'm pulling data manually(by entering specialist name) instead of that I want this query to be modified so that the sys is pulled dynamically, I.e. like select specialist from t. I use oracle 10g not 11.

SELECT
    type, Hari,Rakesh,Santhosh, Total
FROM (
    select
        (type), max( decode( SPECIALIST, 'Hari', cnt, null ) ) Hari,
        max( decode( SPECIALIST, 'Rakesh', cnt, null ))Rakesh,
        max( decode( SPECIALIST, 'Santhosh', cnt, null ) ) Santhosh,
        Sum(cnt) total
    from (
        select
            (type),specialist, sum(update_count) cnt
        from t
        group by (type),specialist 
    ) q
    group by (type)

    Union

    Select
        'Total' as type, Sum(Hari) Hari,Sum(Rakesh) Rakesh,
        Sum(Santhosh) Santhosh,Sum(total) Total
    from (
        select
            (type), max( decode( SPECIALIST, 'Hari', cnt, null ) ) Hari,
            max( decode( SPECIALIST, 'Rakesh', cnt, null )
 )Rakesh,
            max( decode( SPECIALIST, 'Santhosh', cnt, null ) 
) Santhosh, Sum(cnt) total
        from ( 
            select (type),specialist, sum(update_count) cnt
            from t group by (type),specialist 
        ) q
        group by (type) 
    )a
) b Order by Total

Thanks

[Bill Gorder]

Moving this to the JDBC forum for you.