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,

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

Original text of this message