Order By in Nested Tables
From: ExecMan <artmerar_at_yahoo.com>
Date: Wed, 2 Nov 2011 06:48:41 -0700 (PDT)
Message-ID: <26a86cee-5d05-4e5c-be86-01d80bd8365b_at_du8g2000vbb.googlegroups.com>
Hi,
Date: Wed, 2 Nov 2011 06:48:41 -0700 (PDT)
Message-ID: <26a86cee-5d05-4e5c-be86-01d80bd8365b_at_du8g2000vbb.googlegroups.com>
Hi,
Our application has a complex query. The query retrieves data from a table, which contains some nested tables. I'm being asked if the results of the nested tables can themselves be sorted. So, the query is something like this:
SELECT .........
FROM stock_info s, TABLE(estimate_trends) s1,
TABLE(financial_overview) s2
WHERE ticker = 'IBM';
They want the results for the nested tables to themselves be sorted by their first column, which is a sequence number.
Can this be done via normal SQL? Received on Wed Nov 02 2011 - 08:48:41 CDT