![](/uploads/1/2/6/3/126327732/992739349.jpg)
![Postgres view with parameters Postgres view with parameters](http://4.bp.blogspot.com/-CZr1-l9crsc/TkqzxCBSXBI/AAAAAAAAA5Y/WhBPCmw1o8w/s1600/PERCEPCI%25C3%2593N+SONORA001.jpg)
Adding parameterized views is one of the more popular suggestions on the Database Ideas forum:You can get close with syscontext. Though you need to call this to set the value before querying the view:create table t (x int);insert into tselect rownum x from dualconnect by level. Thanks again. One potential issue with adding a column to the view, then filtering on the results, is an 'unpushed' predicate. For small data sets and/or a simple view-query (where the optimizer can transform the query in order to push the predicate), it's not important.However for large data sets, it's the difference between the first SELECT (which mimics a view with a column/parameter) and the second:SQL exec DBMSapplicationinfo.setclientinfo('SYS'); - here's the parameter I want.
Edwards has served Oracle Mining as a director since October 2011 and has. Actual results of current exploration activities; changes in project parameters. Parmetros sonoros. Cualidades o factores que integran y producen el sonido y a travs de los cuales reconocemos sus diferencias. Recursos digitales Parmetros sonoros Secuencia didctica del Recurso de Educacin Musical MOS para conocer los aspectos fundamentales del Sonido a parir del estudio de los parmetros sonoros. Parmetros del sonido.
Owner = 'SYS'PL/SQL procedure successfully completed.SQL select cnt from ( select owner, count(.) cnt from dbasource group by owner ) where owner = userenv('clientinfo');CNT-186,077SQL select count(.) cnt from dbasource where owner = userenv('clientinfo');CNT-186,077Same results, but for a complex query or very large data set, the difference in execution time could be significant.
![](/uploads/1/2/6/3/126327732/992739349.jpg)