Forum Stats

  • 3,837,228 Users
  • 2,262,239 Discussions
  • 7,900,229 Comments

Discussions

SQL Develpoer - Showing Empty SQL script when generating DDL

User_48AND
User_48AND Member Posts: 1 Green Ribbon

Greetings,

I have encountered a problem when trying to generate SQL(with DDL) for a table. I noticed the problem only occurs when I'm not logged into same schema as the table whose SQL script I try to generate. But I can see all the data from tables and other stats. For the ones I don't have privileges I get an error which expected behavior. Here are some screenshots.

In the 'SQL' tab:

When I generate it with 'Quick DDL':

When using 'Save to Clipboard' I get an empty result. When saving to file:

Also when saving to Worksheet I get an empty result.

Has anyone encountered the same problem? Is this expected behavior or could it be a bug?


I'm using:

  • SQL Developer Version: 22.2.0.173 Build 173.2018
  • Java(TM) Platform 11.0.15.1
  • Oracle IDE 22.2.0.173.2018
  • Versioning Support 22.2.0.173.2018

Answers