creating a trigger which inserts data into table A if a row is a created B
SudhirOct 31 2007 — edited Nov 1 2007Hi,
there are 2 tables A and B, A is master table and B is child table,based on 1 master record there exists multiple child record.
i am using cursor loop and retriving the child records horizontally,saperated by "-" ,and when ever any row is added in to child coresponding to a master row,i am taking it in to horizontal row.
now i need to write a trigger ,that will insert the above row in to table A .if any new row is added into table B.
please advice.if any of you are having a sample code.