title: How to call a function with Rowtype parameter from a select statement in Oracle
body: <p>I have an oracle function which has an in parameter which is of rowtype of a table, from a select statement i need to pass the current row to this function so that it does some processing and returns a value. Is there a pseudo variable that can be used within the context of a select statement something equivalent to a old and new in trigger.</p>
  
  <p>I would like to do something like</p>
  
  <pre><code>select *,function1(rowtype) from table1
  </code></pre>
  
  <p>I want to avoid passing multiple parameters, so the question should be seen in that context.</p>