Very often I get asked if ApEx can do this or that, what usually is a functionality available in Oracle. Recently, there was a question if using ApEx, you can operate with nested tables (varrays). My answer is: Sure you can! However, it always depends what you want do do with it.
I created a simple example here. It shows how simple it is to create, insert and query upon nested tables using ApEx.
Hi Denes,
ReplyDeletenice example! Have you also checked out how a tabular form can handle the insert/update?
Patrick