Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: substr etc...

Re: substr etc...

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 03 Jun 2004 10:06:01 +0200
Message-ID: <c9mm5a$367$1@news.BelWue.DE>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US