Ah! Thought so when I looked at the code as it did not look like traditional sql server.
Unfortunately I have not used Oracle and cannot help you, maybe someone else on the forum can.
Sorry I cannot be of more help 
Far away is close at hand in the images of elsewhere.
Anon.