Re: Storing complete table rows in a single field

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 23 Jan 2004 08:42:23 -0800
Message-ID: <1074876077.75624@yasure>

Scott Mattes wrote:

> 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.

Please do. I'd like to give it to my students to study.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Jan 23 2004 - 10:42:23 CST