drop table from oracle db
Answered
I would like to drop tables from an Oracle db. If I want to delete 2 selected tables the following code is generated. Why is a / created?
drop table TABLE_NAME1
/
drop table TABLE_NAME2
/
Can this be turned off somewhere?
Please sign in to leave a comment.
Please check https://stackoverflow.com/questions/1079949/when-do-i-need-to-use-a-semicolon-vs-a-slash-in-oracle-sql.
Thank you for your answer. That explaines the difference between a slash and a simicolon. Which I didn't know.
If I execute the generated command I get an ORA-00933: SQL command not properly ended error. Why does that happen?
That depends on how and where are you trying to execute that. Oracle does not support multiple statements with separators, so DataGrip splits your script into statements and executes them, except cases when you've configured otherwise. So please explain, how are you executing
I configured a database connection on the right outline menu in intellij. There I select some tables and press DEL. Now the screen Confirm Drop is opened. There are a lot of drop table statements like this:
drop table SYS_CONFIG
/
drop table SYS_DB_CHANGELOG
/
If I confirm with OK, I get following message: ORA-00933: SQL command not properly ended. and 1 duplicate reports
I still have this problem.
Hello Matthias,
Please report an issue on YouTrack attaching idea.log ("Help | Show log in...") after restarting IDE and reproducing the issue: https://youtrack.jetbrains.com/issues/DBE