Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 389 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
SQL Developer Does not Generate DDL on SQL tab

Hi,
I recently upgraded my SQL Developer to Version 20.4.1.407.0006.
After the upgrade, SQL Developer does not generate SQL Script on Views.
Please let me know if I have to make any changes in the Preferences.
Answers
-
Well, you could upgrade again to 21.2.1
But also, what version of Oracle Database are you logged into, and are you logged in as the owner of AS_STUDENT_DATA view?
-
I am not the owner. However, I was able to view the SQL (DDL) in SQL developer Version 19.1.
Also, I can see the code in the Details Tab (TEXT) but not in SQL tab. I tried upgrading it to 21.2.1 with the same problem.
-
In older versions we would try to query the data dictionary to get the object DDL if you didn't have the privs for DBMS_METADATA package to generate DDL from the database itself. We no longer do this, if DBMS_METADATA doesn't work, you don't get any DDL for your object.
It's most likely this is causing your issue - ask your DBA to elevate your account privs.
The TEXT field there in the Details tab gives you the most important part of the DDL behind your view as a workaround.
-
We are running into the same problem. It was working in 19.1 but stopped working after we upgraded to 21.4.1.349. Was there a resolution to show the DDL in SQL tab? Can you tell what grants need to be added
-
It may come down to catalog or dba - but really this is a core database issue and not a sql developer one.
-
Did you find an answer?
This is not your imagination. We had exactly the same behavior. We reverted to an instance of SQL Developer 18 on the same workstation, same credentials, etc. and it worked properly. So, it is definitely in the configuration or design of SQL Developer 20 to not display the DDL in the SQL tab or generate the DDL as scripts to a worksheet.
-
Don't agree on it not being a SQL Developer issue. See my previous comments.
-
read what I wrote
In older versions we would try to query the data dictionary to get the object DDL if you didn't have the privs for DBMS_METADATA package to generate DDL from the database itself. We no longer do this, if DBMS_METADATA doesn't work, you don't get any DDL for your object.
-
Missed the first comments.
Thanks.
-
Jeff Smith,
Alright, we granted that permission to our developer's role.
SQL> grant execute on dbms_metadata to ODI_DEVELOPERS;
Grant succeeded.
Our test account, which is assigned the ODI_DEVELOPERS role, does not seem to be able to generate DDL in version 20 or 21 via the SQL tab, as shown here...
Equally, it does not work using the dbms_metadata.get_ddl in these versions.
Both techniques work in version 18.
Any thoughts?