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
ken_at_kentl.com (Captain Cabbage) wrote in
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.
>
> Any ideas?
>
> Ken
If you need to dynamically figure out which columns are in a table I have some code that uses DBMS_SQL to execute any query and display the results no matter what fields were selected on. I can't claim original thought on this, I saw a couple of solutions doing this on the newsgroups somewhere, but at the time I needed it I didn't have internet access and had to code from a vague memory and trial and error (no brag, just claiming any dumb stuff in the code as strictly mine).
If you want it I can send it to you. Received on Fri Jan 23 2004 - 08:01:04 CST