Oracle SQL Developer 20.4.1 - View Object Details Not Showing SQL?

Question

I am using Oracle SQL Developer 20.4.1.407 connecting to an Oracle 11g database

I have a view in the left hand side pane which I click on once and then on the right hand side it pulls up the object details.

So I see multiple tabs

Columns - Data - Grants - Dependancies - Details - Triggers - SQL - Errors

When I click on "SQL" a pop up comes up saying "Generating DDL" then it pulls up blank

Now when I go to the "Details" tab I can see some sort of SQL in the "TEXT" field as shown

So 2 questions

• First I was wondering why doesnt the SQL just show up in the SQL tab? Is this a permissions issue with my loggged in user?

• Second if the SQL is shown in the details TEXT column why have a SQL tab at all? Whats the difference between the two spots?

Thanks in advance

Answer 1

For a view, this is most likely a privileges issue.

For example, if I logon as SCOTT on my database, I can click on views in the SYS schema and see their Details, eg

But if click DDL, then I'll get a blank because I don't have privileges to query the contents of the view or its definition.

Views are an "odd" case, because the DDL is virtually synonymous with the data in ALL_VIEWS.TEXT_VC.

Sidenote: SQL Dev 20 is long in the tooth. Its trivial to upgrade so why not head over to SQL Dev 22.