after "/where" the user can add his portion of where statement that can be utilized in the creation of a secure view.
Use Case
Multi-tenant applications require all tables to be accessed through secure views. Having where statement ready with the argument, will make the development of the script tremendously easier and accurate.
To create quickly secure views for multi-tenant applications, allow a switch line
Example:
view Knowledge_articles_v Knowledge_articles /where tenant_id = SYS_CONTEXT('APEX$SESSION', 'APP_TENANT_ID');
after "/where" the user can add his portion of where statement that can be utilized in the creation of a secure view.
Use Case Multi-tenant applications require all tables to be accessed through secure views. Having where statement ready with the argument, will make the development of the script tremendously easier and accurate.