(Pl/SQL) Obtaining field names from record 'variable'
От | Allan Kamau |
---|---|
Тема | (Pl/SQL) Obtaining field names from record 'variable' |
Дата | |
Msg-id | 248682.35322.qm@web53508.mail.re2.yahoo.com обсуждение исходный текст |
Ответы |
Re: (Pl/SQL) Obtaining field names from record 'variable'
|
Список | pgsql-admin |
Hi, I am writing a PL/SQL script to process data from a high dimensionality table where this table has most of it's field namesencapsulating data. I would like to automatically loop through the fields of a RECORD variable (returned from a cursor)obtaining the field name and the field value. For example my table is listed below (briefly) create table my_table ( id int not null-- default nextval(('my_table_seq'::text)::regclass) ,some_explanation varchar(20) not null ,D30 varchar(100) null ,W32 varchar(100) null ,C33 varchar(100) null ,V7 varchar(100) null ,... ) ; The field name W32 consists of 'W' which is data I need and '32' which is data I also need along with the actual record valuecontained in this field. Allan. ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
В списке pgsql-admin по дате отправления: