What makes you think that the SQL as shown is specific to Oracle?

Also, why are you posting nonsensical syntax errors in what looks like it could be meant as Perl code?

Maybe you want to tell us what syntax errors you actually get?