This works on functions, procedures, packages, types, synonyms, trigger and views. Update: After updating the post for the third time, I’ll reformulate this: This does not work on tables 🙂 And yes, there is documentation on this syntax, and there are no REPLACE option for CREATE TABLE.
I think you should not rely on the implicit conversion. It is a bad practice. Instead you should try like this: or like
I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query: it displays the following error: ORA-65096: invalid common user or role name in oracle. Basically it is not allowing me to … Read more