SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Delete using data from external table

600711Jan 17 2011 — edited Jan 17 2011

Hi,

Please could someone help me out with the statement to delete an entire row from referencing a person_id on a internal table where it matches the person id on an external one? I have the update statement below, but also need to know how to do delete (for the entire row, not just one column).

Update XX_SQL_LOADER_TEST SLT
set emp_number = (SELECT emp_number from XX_EXTERNAL_TBL ET where ET.Person_id = SLT.PERSON_id)
, emp_name = (SELECT emp_name from XX_EXTERNAL_TBL ET where ET.Person_id = SLT.PERSON_id)

Many Thanks

Steve

Edited by: SteveCPP on Jan 17, 2011 1:19 PM

This post has been answered by Frank Kulash on Jan 17 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2011

Added on Jan 17 2011

2 comments

534 views