I am not able to view my data in my oracle forms 6i database is 11g
-
i wish to actually view my data in a oracle form developed on 6i based on date parameter but if i try to work on my oracle forms it dosent give me data acoordingly here is the query whcih i am using
SELECT e."Deal_No" deal_no, e."Remarks" Counterparty, m."MaturityDate" Maturity_Date, m."PriRedem" Principal,
(m."MaturityDate" - To_date) Days_to_Mat
FROM MM_T_BORROWING e, MM_T_BORROWING_PM_DETAIL m
Where e."DeskCode" in ('10','11','12','13') and e."Value_Date" <= to_date and e."Maturity_Date" > to_date and e."Status" not in ('C', 'D', 'Z', '0','X')
and e."Deal_No" = m."Deal_No" and "PriRedem" > '0' and m."MaturityDate" > to_date ; -
i wish to actually view my data in a oracle form developed on 6i based on date parameter but if i try to work on my oracle forms it dosent give me data acoordingly here is the query whcih i am using
SELECT e."Deal_No" deal_no, e."Remarks" Counterparty, m."MaturityDate" Maturity_Date, m."PriRedem" Principal,
(m."MaturityDate" - To_date) Days_to_Mat
FROM MM_T_BORROWING e, MM_T_BORROWING_PM_DETAIL m
Where e."DeskCode" in ('10','11','12','13') and e."Value_Date" <= to_date and e."Maturity_Date" > to_date and e."Status" not in ('C', 'D', 'Z', '0','X')
and e."Deal_No" = m."Deal_No" and "PriRedem" > '0' and m."MaturityDate" > to_date ; -
i wish to actually view my data in a oracle form developed on 6i based on date parameter but if i try to work on my oracle forms it dosent give me data acoordingly here is the query whcih i am using
SELECT e."Deal_No" deal_no, e."Remarks" Counterparty, m."MaturityDate" Maturity_Date, m."PriRedem" Principal,
(m."MaturityDate" - To_date) Days_to_Mat
FROM MM_T_BORROWING e, MM_T_BORROWING_PM_DETAIL m
Where e."DeskCode" in ('10','11','12','13') and e."Value_Date" <= to_date and e."Maturity_Date" > to_date and e."Status" not in ('C', 'D', 'Z', '0','X')
and e."Deal_No" = m."Deal_No" and "PriRedem" > '0' and m."MaturityDate" > to_date ;You probably are not getting any results because you have not defined the parameter to pass to the to_date function. to_date (string_to_convert_to_date, [optional parameters if required]). If you are trying to pull from "today" then use to_date(sysdate)
