SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Semicolon gives error

jflackJul 23 2020 — edited Jul 23 2020

Running SQL Developer 19.4 against a RDBMS 12.2

Got a rather large INSERT SELECT.

Put a semicolon on the end of the SQL, and I get the error:

Error report -

SQL Error: ORA-00933: SQL command not properly ended

00933. 00000 - "SQL command not properly ended"

Remove the semicolon, and it runs fine.

Ideas?

The SQL is eventually going to run in JDBC and it usually wants that terminator. I can do "no semicolon" for testing, "with semicolon" for real. But it's annoying me.

Added on Jul 23 2020

#sql

2 comments

1,825 views