![]() ![]() To learn more about these subscription offerings, visit. Inner join portfolio p on p.portf_id = gpr.portf_id and p.is_composite != 2 -2 means compositeĪnd gpr. The Toad for Oracle Base Edition, Toad for Oracle Professional, Toad for Oracle Professional DB Admin, and the fantastic Toad for Oracle Xpert Plus are available for an affordable annual price. ,(exp(sum(ln(1 + gpr.bmk_perf)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_bmk ,(exp(sum(ln(1 + gpr.portf_perf_net)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_ptf_net ,(exp(sum(ln(1 + gpr.portf_perf_gross)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_ptf_gross The reason I don't want a cursor returned is that when I select the function one cell is returned saying (cursor) instead of displaying one row with 4 columns of data. I have read on google about returning the data as a %rowtype but I do not seem to be able to get it to work. However I need it to return just one row. Have a function below that returns a cursor. 9 years of IT experitence in analysis, design, development, implementation and testing as Oracle SQL/PLSQL Developer.Hands - on experience in all phases of system development & software development with well-defined Quality Standards Requirement Analysis, Design, Development, Testing & Implementation.
0 Comments
Leave a Reply. |