![]() Inner join portfolio p on p.portf_id = gpr.portf_id and p.is_composite != 2 -2 means compositeĪnd gpr. To learn more about these subscription offerings, visit. ![]() ,(exp(sum(ln(1 + gpr.bmk_perf)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_bmk 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.portf_perf_net)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_ptf_net Share code, scripts, artifacts, standards, and best practices with the team or across the development organization through integration with the Toad Intelligence Central application. ,(exp(sum(ln(1 + gpr.portf_perf_gross)) over (partition by p.portf_code order by end_date)) - 1) as chain_linked_ptf_gross This database toolset is unrivaled for ensuring the most significant possible productivity in the development and administration of Oracle databases. 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.
0 Comments
Leave a Reply. |