Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Storing complete table rows in a single field
Uzytkownik "Captain Cabbage" <ken_at_kentl.com> napisal w wiadomosci
news:41d41973.0401220937.223b9f5c_at_posting.google.com...
> 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.
>
Just do history table as copy of main one, with additional columns who and
when changed.
Then create trigger to fill history table when any delete/update occurs.
Fill history table with :new data.
Making one row from all column maybe dificult when length of data exeed 8000
(max for varchar2)
unless you use a BLOB's, but it's sounds horrible to me.
-- NoelReceived on Fri Jan 23 2004 - 08:41:21 CST