Subject | LIST function with order by |
---|---|
Author | legrand_legrand_63 |
Post date | 2007-07-08T11:53Z |
Hello,
I'm confused with the LIST built-in function.
It seems not possible to use it in non-aggregate statements with ORDER
BY, for example:
select list(column_name) from all_tab_columns
where table_name='VV'
order by column_id;
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause).
Could this be changed ?
Regards
PAscal
I'm confused with the LIST built-in function.
It seems not possible to use it in non-aggregate statements with ORDER
BY, for example:
select list(column_name) from all_tab_columns
where table_name='VV'
order by column_id;
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause).
Could this be changed ?
Regards
PAscal