ORA-00911 What am I doing wrong? Oracle

Question

Here is my code:

DROP TABLE cover_resp;
DROP TABLE cover;
DROP TABLE absence;
DROP TABLE sickness;

select constraint_name, constraint_type, table_name
from user_constraints
where table_name IN ('SICKNESS' , 'ABSENCE' , 'COVER' , 'COVER_RESP')

What am I doing wrong? I keep getting the same ORA-00911 error message.

Answer 1

Nothing Seems to be wrong with your code. However ORA:000911 stands for invalid character.

Try to retype your code and run it again.

Answer 2

a typical situation is the "non-breaking" space which looks like a normal space, but is a different character. On a Mac, you get it woth [Option] + Space. Whenever something like this is in your code, you will get the ORA-911 ...

Hope that helps