Re: Column names in the OLD and NEW virtual tables

From: Paul Brownjohn <Paul-no-spam-_at_brownjohn.co.uk>
Date: Tue, 22 Feb 2005 19:34:07 +0100
Message-ID: <421b7c39$1@news.vo.lu>

Mark D Powell wrote:
> I will second Daniel's NO, and point out that dba_tab_columns is
> available along with a little pl/sql to write code to generate audit
> triggers which are about the only type of trigger activity where this
> feature (not knowing column names) would be useful.
>
> HTH -- Mark D Powell --
>

You are quite right the idea was to write a script to create audit triggers.

In the end I used info from user_tab_cols to do the job

Cheers

Paul BJ Received on Tue Feb 22 2005 - 12:34:07 CST