how to access the data to one to many relationship

Select or download this

 tar : ERGC [1] | ALX5 [2] | PT2 [3] | PRTD [4]  act:  Ago [1] : Inhib
+it [2,3,4]

Select or download this

insert into Table1 values(sq_tab1.nextval,'ERGC','AGO');
insert into table1 values(sq_tab1.nextval,'ALX5','inhibit');
insert into table1 values(sq_tab1.nextval,'PT2','inhibit');
insert into table1 values(sq_tab1.nextval,'PRTD','inhibit');

Select or download this


      my @targets = split (/\|/,$mech_results->{'Targets'}); 
...
                
          }
        }

Select or download this

1,1 ERGC, Ago
2,2 ALX5,  Inhibit
3,2 ALX5,  Inhibit
4,2 ALX5, Inhibit

Select or download this

1,1 ERGC, Ago
2,2 ALX5,  Inhibit
3,3 PT2,  Inhibit
4,4 PRTD, Inhibit

Select Code to Download