in reply to Using perl how to extract only the source_profile_id and target_profile_id from a xml file and generate sql delete statements based on the comparison between the extracted ids from xml file and the ids present in the oracle database?

Welcome to the Monastery. You've posted this in the wrong section of the forum, see Where should I post X?. Your entire question seems to be in the title field, see How do I compose an effective node title?. You've simply pasted an xml file (without using code tags), no details on your platform or what you've tried already, see How do I post a question effectively?. All of this advice is displayed on screen when you are posting, please don't ignore it.

Update: see XML Technologies and Database Programming from the tutorials section of the site.

  • Comment on Re: Using perl how to extract only the source_profile_id and target_profile_id from a xml file and generate sql delete statements based on the comparison between the extracted ids from xml file and the ids present in the oracle database?

In Section Seekers of Perl Wisdom