Oracle 11gR2 - View Function Columns Evaluation
Hi All,
I seem to have an odd issue regarding an Oracle view that has functions defined for columns and when those functions are evaluated.
Let's say I have the following view and function definition:
<span class="kwd" style="color: #00008b;">CREATE</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">OR</span><span class="pln" style="color: #000000;"> REPLACE </span><span class="kwd" style="color: #00008b;">VIEW</span><span class="pln" style="color: #000000;"> test_view_one </span><span class="kwd" style="color: #00008b;">AS</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">SELECT</span><span class="pln" style="color: #000000;"> column_one</span><span class="pun" style="color: #000000;">,</span><span class="pln" style="color: #000000;"> a_package</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">function_that_returns_a_value</span><span class="pun" style="color: #000000;">(</span><span class="pln" style="color: #000000;">column_one</span><span class="pun" style="color: #000000;">)</span><span class="pln" style="color: #000000;"> function_column </span><span class="kwd" style="color: #00008b;">FROM</span><span class="pln" style="color: #000000;"> a_table</span><span class="pun" style="color: #000000;">;</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">CREATE</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">OR</span><span class="pln" style="color: #000000;"> REPLACE PACKAGE BODY a_package </span><span class="kwd" style="color: #00008b;">AS</span><span
0