Using v4.0.2, Tools > Database Export
Selected 3 tables to Worksheet
I get semi-colons after each of my three create table statements.
Thank You very much, Jeff for your response!
In the meantime I founded out, that the missing rights on the package DBMS_METADATA cause my problem with delimiters.
The SQL Developer seems in this case to generate DDL on its own and to do it not very well.
Yeah, the code we fall back on if you don't have access to DBMS_METADATA is a 'best try' kind of thing. If you're going to be doing this a lot, get your DBA to grant you execute privs on that package. Or just ask them to generate the scripts for you.
the code we fall back on if you don't have access to DBMS_METADATA is a 'best try' kind of thing
Hmmm - is 'best try' a new euphemism for 'bug'? Or is it for 'works as designed'?