USER_TAB_COLUMNS

From: UnixDBA <unixdba_at_aol.com>
Date: 5 May 1999 05:36:54 GMT
Message-ID: <19990505013654.07263.00002727@ng-ck1.aol.com>

     Just retrieve the column names for the table from USER_TAB_COLUMNS:
     
     select column_name
     from USER_TAB_COLUMNS
     where table_name = 'LANGUAGES'
     /


______________________________ Reply Separator
_________________________________

Subject: dba_tab_columns
Author: Non-HP-UnixDBA (UnixDBA_at_aol.com) at HP-Roseville,mimegw5 Date: 4/25/99 10:35 PM

Subject: Field names?
From: "David Younger" <david_at_proware.com.au> Date: 4/25/99 8:10 PM EST
Message-id: <7g0bg5$3mb$1_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 Wed May 05 1999 - 00:36:54 CDT