Storing complete table rows in a single field
I need to be able to store complete rows retrieved from various tables (SELECT * ...) as a single field in another table. Basically I need to keep a record of every change made to various tables, like an audit trail, but I need the entire record not just the changes.
I can do this in SQL Server but now I need to port it to Oracle.
I get the feeling that Object Tables and %ROWTYPE comes into it somewhere but I can't quite get it all to work together.