Update on ORACLE-DB with subselect

Thread View: comp.lang.pascal.delphi.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Carsten Wed, 03 Nov 2004 10:51

Author: Carsten
Date: Wed, 03 Nov 2004 10:51

20 lines
1282 bytes

Hi,
I'm desparate on finding a way to execute a statement like:

-------- snip --------
UPDATE ":ORA_CONNECT:ORA_TABLE" ot
SET ot.col = 'something'
WHERE ot.onecol = 42
AND   ot.othercol IN (
  select col from ":BDE_DB:BDE_TABLE" WHERE something is true
);
-------- snap --------

The statement is working without "AND   ot.othercol IN (...".
Subselect itself is working too.
Oracle is 9.2.

Any ideas?
Please help

Carsten

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads