select "triggers"

Oracle 9i introduced Fine Grained Auditing whereby when data is selected from a table,
audit event handler can be invoked to track changes. I, however, want to do follwing:

when a row is selected, I want to modify its data before it is returned to user.
I cannot do it in application code because my application is third party. Is there something like a insert trigger for select (reverse of insert), where value returned can be modified, e.eg.m if data was stored in a column in compressed fsaion, I want to return it as uncompressed in a "select" trigger.

I looked at FGA, I could not find anyway to aalter returned data.

Appreciate any help,

Thanks a lot. Received on Wed Apr 28 2004 - 22:38:01 CDT