Deleting rcords from table based on incoming column value

[amreesh_singh]

Hi,

File ---------trans---------oracle table

If the value read from the file is present in the oracle table for the perticular column , then delete all records from table with the same column value.
Input File Column : A
Target Clomun : B

I have used the Write Method as Delete Rows , the issue is with the query

DELETE
FROM
table_name
WHERE
B = ????

how to get the column value , it should have the value of column A

[ray.wurlod]

Deliver the value of A on the link as a column called B and marked as Key.

Code: Select all

DELETE FROM table_name WHERE B = :1