Re: substr etc...

danthefirst2000_at_yahoo.com wrote:
> 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

Get rid of one of the tables and learn to

1. concatenate a string (keep tableB)
2. pivot in SQL (keep tableA)

I'd go for a) if I were you, but with the lack of any information as what those tables are for, I really couldn't say.

HTH Holger Received on Thu Jun 03 2004 - 03:06:01 CDT