This method creates a read-only viewObject at runtime when the query is processed in the method, In this post, I am going to show you that how can we use SQL queries at runtime to create a dynamic view object.
Follow these simple steps-
- First, create a dummy ViewObject using dual
- Now add this ViewObject to Application Module
- Get application module using data control and call method to create dynamic ViewObject at runtime.
Get Application Module-
Create dynamic View Object-
- Now Run your application and put different SQL queries to generate and get row count of the view object
Download –Sample ADF Application
Cheers 🙂 Happy Learning
I’m an Oracle ACE, Blogger, Reviewer,
Technical Lead working on Oracle ADF