Skip to Main Content

SQL Developer

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!

Using the side bar to view columns when expanding the table

3681596Mar 29 2018 — edited Mar 29 2018

Hi, I'm new to Oracle SQL Developer; when I expand the table name on the left side pane, it doesn't give me a list of columns in that table.  Instead, it runs a select * on that table then I can click on the "Column" table in the right pane.  I'm sure there is a setting somewhere to control this but I cannot find it.  I found another discussion thread here on turning off the "Open Object on Single Click" option in Tools, Preferences, Database, Object Viewer.  That only prevents it from running a select * when I click on the table name, I still do not see a list of columns.  I'm on Version 4.2.0.16.260, Build 16.260.1303.  Any help on this would be great as this is very annoying that I cannot see the list of columns unless you run a select *.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2018
Added on Mar 29 2018
6 comments
5,846 views