您可以使用合并到来完成它。没有提供示例数据-我将创建一些只是作为示例：

CREATE TABLE
    TABLE_A (ID, FOO) AS
        (   Select '123' "ID", 'X' "FOO" From Dual Union All
        Select '456', 'X' From Dual Union All
        Select '789',  'X' From Dual 
        );
--  ID  FOO
--  --- ---
--  123 X
--  456 X
--  789 X
CREATE TABLE 
    TABLE_B AS
        (   Select '123' "ID",  To_Date('01.01.2023', 'dd.mm.yyyy') "START_DATE", To_Date('31.12.2023', 'dd.mm.yyyy') "END_DATE" From Dual Union All
            Select '456',  To_Date('01.01.2023', 'dd.mm.yyyy'), To_Date('30.06.2023', 'dd.mm.yyyy') From Dual Union All
            Select '789',  To_Date('01.01.2023', 'dd.mm.yyyy'), To_Date('31.12.2023', 'dd.mm.yyyy') From Dual 
        );
--  ID  START_DAT END_DATE 
--  --- --------- ---------
--  123 01-JAN-23 31-DEC-23
--  456 01-JAN-23 30-JUN-23
--  789 01-JAN-23 31-DEC-23

字符串
现在我们可以连接表并定义FOO列的值：

Select        a.ID "ID",  
            Case When b.ID Is Null Then 'N' Else 'Y' End "FOO"
From            TABLE_A a
Left Join   TABLE_B b ON(b.ID = a.ID And a.ID In('123', '456') And
            TRUNC(SYSDATE) Between b.START_DATE And b.END_DATE)
Where         a.ID In('123', '456')
--  ID  FOO
--  --- ---
--  123 Y
--  456 N

型
MERGE INTO可以使用上述查询来更新列FOO

Merge Into TABLE_A t
Using   (   Select        a.ID "ID", --b.START_DATE, b.END_DATE, 
                      Case When b.ID Is Null Then 'N' Else 'Y' End "FOO"
          From          TABLE_A a
          Left Join     TABLE_B b ON(b.ID = a.ID And a.ID In('123', '456') And
                      TRUNC(SYSDATE) Between b.START_DATE And b.END_DATE)
          Where           a.ID In('123', '456')
        ) x ON(x.ID = t.ID)
WHEN MATCHED THEN UPDATE SET t.FOO = x.FOO
Where t.ID In('123', '456')
--  2 rows merged.

型
你应该调整它以满足你的上下文。确保行是1到1连接的，以避免错误消息，并确保在表a中寻址正确的行。这可以在所使用的查询中或在ON条件中或在Where子句中完成，或者它们的任何组合，

--  R e s u l t :
Select * From TABLE_A
--  ID  FOO
--  --- ---
--  123 Y
--  456 N
--  789 X

型