Home » SQL & PL/SQL » SQL & PL/SQL » how to dynamically access members of a record structure..
how to dynamically access members of a record structure.. [message #207115] Mon, 04 December 2006 03:34
tosanu
Messages: 7
Registered: December 2006
Location: INDIA
Junior Member

hi all..

i have a record structure like this...

create or replace type rec1 is record (
m1 varchar2(50);
m2 varchar2(50);
.
.
.
.
m50 varchar2(50);
);

and i need to compare each member of the record with a value like this...

....
r1 rec1;

....
if r1.m1 = 'abc' or r1.m2 = 'abc' or .... then
flag = 1;
end if;
....

instead of hardcoding each member of the record structure, is there any other way to access it dynamically,
may be inside a loop.. ?

thanks in advance

sanu


Previous Topic: Alter table and Add Constraint
Next Topic: SQLPLUS login problem URGENT !!!
Goto Forum:
  


Current Time: Fri Dec 09 11:58:27 CST 2016

Total time taken to generate the page: 0.09767 seconds