I have a query where I want to copy data from web and pass it to oracle database. How to do that?
Use Get Text / screen scraping / Recording - Copy Text/ Select & copy activity to grab the text from the webpage
Parse the result in a way that it is ready to be passed as a parameter to the query
Use the Database activities to send in your query
Hope it helps