ora-00933

That syntax isn’t valid in Oracle. You can do this: Or you might be able to do this: It depends if the inline view is considered updateable by Oracle ( To be updatable for the second statement depends on some rules listed here ).