Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> update statement
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