Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX 5.1 interactive grid - how to add a pseudocolumn

franklin.jrJan 24 2017 — edited Feb 3 2017

I need to add a pseudocolumn on an interactive grid, so I need to know which parameters must be set to make it work. This pseudocolumn is based on the following instruction: row_number() over (partition by column group by column). I tried to add this pseudocolumn in my select list of columns, however it is causing error while saving because this content is not related to any database column at the table. Previous attempts led to an ORA-30483 (window functions are not allowed here) error. Thanks in advance.

This post has been answered by Patrick Wolf-Oracle on Jan 25 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2017
Added on Jan 24 2017
10 comments
5,071 views