HOW TO CREATE A VIEW WHICH CONTAINS A PARAMETER

Periodically you may run into a situation where it is beneficial to create a view that permits parameters to be passed to it. Views by design do not provide such functionality. However, by using the client_info portion of the DBMS_APPLICATION_INFO you can accomplish this.

Pages: 1· 2