The preferences dictate when the code assist features kick in. In 4.0.3 we filter the advice for the automatic bits when there are more than 10 suggested identifiers. So, typing:
select * from
...on a large schema, you'd likely not see any suggested table or views names, unless you invoked the helper directly via ctrl+spacebar.
As you type more, the more likely the suggested values will be of more value. The default settings will have automatic popups after .6 seconds and the number of hits goes below 10.
Tools > Preferences > Code Editor > Completion Insight
Make sure you don't have the first two items disabled. And try increasing the filter to something higher than 10. Examples of different insight 'helpers' and a video demo here.
You can set your own NULL text, that's in the preferences. I have a bug logged so you can set the NULL coloring AND use the zebra styling (fixed in version 4.1, soon to be released.) And I also have an ER logged for custom colors on the 'zebra' styling.
We fixed that bug, go get v4.1.1 - null color + zebra grids work now.
I feel really stupid for not thinking about this earlier. I'm so used to SQL Management Studio not requiring changes to be committed. I also thought that the changes were being committed on oracle, because my select statements reflected the changes made.
I found the solution to my problem was upon changing data in Oracle SQL Developer I needed to explicitly
commit;
Now the updated data is available through my linked server.
Best Answer
I did a google search for the phrase "sql developer code formatting", and the first hit was this:
http://www.thatjeffsmith.com/archive/2014/03/how-to-make-your-code-look-like-steven-feuersteins-in-oracle-sql-developer/
Have a read through that blog post from Jeff Smith, product manager for SQL Developer. That should explain what you need to do.
Edited to add picture of the relevant options.
