Can we create a view with one of the columns being populated using a pl/sql script, that uses 2 other columns on the same row as input ?
Example,
Let's say I have a view with
Reg. No | Total | Customer Account | Billing Flag | CodeFn
1234 $45 2109 Y <The value in this column would be what the intended pl/sql script returns, after using the Reg# (1234) and Total(45) as Inputs>
1236 $15 2101 Y <The input values would be 1236 & 15>.
Basically, I'd like the script to generate a number that's returned in that column as opposed to doing a simple Select stmt to retrieve columns from other tables/views.
Edit: The view doesn't show up right ..so here's an image
view
Thanks!
Edited by: jess_saunders on May 8, 2012 2:05 PM