substr etc...

Guys , got a question for you.

I have 2 tables

tableA

1a (PK)                 XYZ  


-----------------------------------------------------------

1                       abc:string  def:string   ghi:string
2			def:string   ghi:string  
3			abc:string   ghi:string     

and so on... lets say the string is 10 chars.

I have a another table
tableB

tableB

1a            abc               def                  ghi  


--------------------------------------------------------------

1             string            string               string
2                               string               string
3             string                                 string

1a – PK
abc varchar2 /*column reference to the value on XYZ from tableB */ def varchar2
ghi varchar2 so on

I want to write a piece of code ( a trigger ?) that every time tableA column XYZ's one of the piece of strings (ie lable ghi in the second row) get updated tableB referencing column value need to change. Do you get the drift?
Any help would be great….Where do I start?

Thanks,
Dan Received on Thu Jun 03 2004 - 01:26:53 CDT