Oracle deletes tables with spaces

When using the SQL statement generated by powerdesigner to create a table, I do not know how to add a space in the table name. I did not care to directly run it in PL/SQL, it is difficult to use the statement or right-click to delete the file. When you delete a table with the drop command, the message "ORA-00933: SQL command is not completed correctly" is displayed. If you encounter this problem, you can use "" on the table name and then delete it.

But I still do not, with the quotation marks after the prompt, "ORA-00604: recursive SQL Level 1 error, ORA-01422: the actual number of returned rows exceeds the number of rows in the request ", to solve this problem, log on to the system account and run delete from dual. You can run select * from dual first. There will be two Y values in it, and then run the delete statement, A column Y is automatically retained. After deletion, the table can be deleted by executing the drop statement.