5 Replies Latest reply on Mar 12, 2014 12:34 AM by Gary Graham-Oracle

    Can't see columns beginning with "." in Data tab

    HiddenPublicName

      Hi all,

       

      Apologies if this is a basic question, or if it's been answered before (couldn't find anything addressing it).

       

      I was using SQL Developer 3.1.  I am trying to view a table that has some column names beginning with a dot, ".".  When I look at the "Columns" tab, it shows me all the columns correctly, but when I click on the "Data" tab, it omits all columns beginning with a dot.  I can't see them, can't sort on them if I click sort, can't add them if I try to right-click on a column and go to "Columns...", can't query on them using that "Filter" bar (it says "invalid identifier").  Nothing.  Worksheet queries work fine, but this small thing is bugging me.  Do I need to change some preference I haven't found?

       

      I tried updating to 4.0.1 to see if that would fix anything, but it's the same.

       

      Thanks in advance for any help you all can offer!