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?

On Nov 2, 6:48*am, ExecMan <artme... (AT) yahoo (DOT) com> wrote:
SQL is relational, nested tables are object-relational extensions to
oracle. So, I don't know.

See http://technology.amis.nl/blog/1217/...-heavy-lifting
(found by googling oracle sort results from nested table) and don't be
put off by the subject of that post, check out how the sort is done.

jg
--
@home.com is bogus.
"ORA-01536 space quote exceeded for tablespace string" - 11.2 docs

On Nov 2, 12:12*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:

That is a good article. I'm not 100% sure it is what I want, as I
have several nested tables, and the application wants each one sorted
be it's first column, the sequence #. I think this is a good starting
point though.