Today i encountered with the same problem and don't know how to write an update the select update query in Oracle, then i found a software SwisSQL. It makes my life paradise. http://www.swissql.com/products/sql-translator/sqlone-consolejavadownload.html

Just Copy your T-SQL and it will convert it to PL-SQL and in so many other languages.