using where

[swati.mohanty]

i want to pass parameter with pivort table for the date field which i'm using for oracle querry. Could u please tell me how i can handel this parameter??

SELECT * from (select WILAYAT_DESC_E "FISH LOCATION",WEIGHT Quantity,
(PRICE_PER_KG*WEIGHT) VALUE,
sum(ST_EXPORTINFM_TT.WEIGHT * ST_EXPORTINFM_TT.PRICE_PER_KG) as "SUM OF VALUE",
sum(ST_EXPORTINFM_TT.WEIGHT) as "SUM OF WEIGHT",
(EXTRACT(MONTH FROM DATA_ENTRY_DATE_TIME)) AS  MONTH
FROM ST_EXPORTINFM_MT inner join ST_EXPORTINFM_TT on
ST_EXPORTINFM_MT.ID_EXPORT=ST_EXPORTINFM_TT.ID_EXPORT
inner join HR_WILAYAT_MT on
HR_WILAYAT_MT.ID_WILAYAT=ST_EXPORTINFM_TT.ID_WILAYAT GROUP BY WILAYAT_DESC_E, WEIGHT, (PRICE_PER_KG*WEIGHT), (EXTRACT(MONTH FROM DATA_ENTRY_DATE_TIME)) order by WILAYAT_DESC_E )
PIVOT (sum(value) for MONTH
IN (1 as "JAN ",2 as "FEB ",
3 as "MAR ",4 as "APR ",
5 as "MAY ",6 as "JUN ",7 as "JUL " ,
8 as "AUG ",9 as "SEP ",10 "OCT ",
11 as "NOV ",12 as "DEC "))

i just want to pass the parameter for above bold field in this querry as i'm using table format. could u please assist me???

 

 

[sambitgudu]

Not getting your query ??  Can you elaborate your requriment ??