Oracle UPDATE as a inner query inside a where clause

  • For support and Advertisement ICQ: 481465 Jabber: verifiedcarder@xmpp.jp
#1
I want to insert some values to a table based on the number of updates made by the same query.
An example queries I tried is as follows.
SELECT column1 column2
FROM table_A
WHERE (UPDATE table_B
SET column3= "?"
WHERE column3 = "?"
RETURN "UPDATED ROW COUNT") > 10
There can be many other ways to do this. But I explicitly Ethical Hacking want the update to execute on within the WHERE clause. This is to be used for a ethical hacking scenario.