Re: Field names?
From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Mon, 26 Apr 1999 17:03:12 +0100
Message-ID: <7g22ld$jvt$1_at_news7.svr.pol.co.uk>
Date: Mon, 26 Apr 1999 17:03:12 +0100
Message-ID: <7g22ld$jvt$1_at_news7.svr.pol.co.uk>
[Quoted] You can query the data dictionary for the table (e.g. all_tab_columns or some such). If you ever manage to write a generic utility of this type, I'd be interested to see it, as it would be very useful.
Simon Hedges
Gloucester
UK
>David Younger wrote in message <7g0bg7$3mb$2_at_news.eisa.net.au>...
>In a PL/SQL script, how can I programatically iterate through all the
fields
>in a table without specifically knowing the field names?
>
>Specifically, I am trying to write a generic auditing function that will be
>triggerd on insert, update and delete that will be passed the table name
and
>will write out all the old/current values of each field.
>
>Thanks
>David Younger
>
>
Received on Mon Apr 26 1999 - 18:03:12 CEST