Hi, I am fairly new to PL/SQL. And I am learning to create an analytical function that allows me to fetch t+5*n days' data. For instance, today is 20100630, what are S&P 500 closing prices 5, 10, 15, 20, 25, 30, ....up to 300 days later? I do have a table that is like a calendar, which makes it easier to pick only trading dates when the stock market is open. In the output, I will have one row (today's date), with 300/5=60 columns (5, 10, 15, 20, 25...300 days later). Could anyone help me with this analytical function? I have never written one before.
Thank you very much! I truly appreciate it. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
