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 -> update statement

update statement

From: <analyst_user_at_my-deja.com>
Date: 2000/08/04
Message-ID: <8mf32i$5ni$1@nnrp1.deja.com>#1/1

I have two tables that look like the following.

CODE_TABLE

CODE          SYMBOL
12            T,W,R
11            W,Q
10            E

SYMBOL_XREF
OLD_SYMBOL        NEW_SYMBOL
T                 TX
W                 WY
R                 RV
Q                 QU
E                 EP


I want to update the CODE_TABLE with the new symbols from the SYMBOL_XREF table.

The problem is that the SYMBOL field of the CODE_TABLE is comma delimited with multiple values.

Any help would be greatly appreciated.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 04 2000 - 00:00:00 CDT

Original text of this message

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