You would probably have to use a programming language, like Delphi.
"Kamal" <kamal80_at_virgilio.it> wrote in message
news:4e766a02.0301230304.71d7edd7_at_posting.google.com...
> Hi everybody.
>
> Does anyone know how to have a list of the variable inside a record
> declared like this:
>
> rec1 table_name%rowtype;
>
>
> I could retrieve the field name from the dictionary views like
> user_tab_columns or similar, but what can i do if "table_name" is a
> synonym? Maybe pointing to a db link? And if the db link points to
> another synonym pointing to another db link etc etc? Is there a
> straight way to know all the fields inside this record variable?
>
> TIA
>
> Kamal
Received on Thu Jan 23 2003 - 08:48:36 CST
