Video: Completion Insight in Oracle SQL Developer v4.0.2

thatjeffsmith SQL Developer 15 Comments

Tell Others About This Story:

I said earlier today that version 4.0.2 of SQL Developer consisted on ONLY bug fixes. I should have said MOSTLY bug fixes.

There was also one minor tweak, although it was a minor tweak to a major feature: Completion Insight.

This is the feature that kicks in while you are typing – suggesting column or table names to help you complete your SQL statements in an editor. Watch this quick video to see it in action.

Tell Others About This Story:

Comments 15

  1. Hi,
    I installed version sqldeveloper-4.1.3.20.78-x64 and ctrl-space doesn’t work for Completion Insight. I am using DB2 as a database and used required jar to add new connection.
    Is the Completion Insight not working because I am using DB2 rather Oracle?

    Regards,
    Piyush

    1. thatjeffsmith Post
      Author
  2. I installed Version 4.0.3.16 Build Main-16.84 and my Insight is also no longer working. Unchecked and checked all boxes in features and it doesn’t change anything. Definitely a bug.

    1. thatjeffsmith Post
      Author
  3. Observing a strange behavior:
    1. Complt.Insight not working by itself, but works when press Ctrl-Space;
    2. It shows only tables/views; when typing . no table fields are displayed, even after Ctrl-Space.
    I’m running in debug mode, which produces a lot of messages in the log.
    What exactly I should be looking for with regards to the above Complt.Insight problem…? I don’t see any particular msg with sql populating insight list…

  4. hi Jeff,
    I recently installed SQLDeveloper 4.0.2.15. Completion Insight simply not working!! :(. Obviously checked menu Tools->Preferences for this feature, seem to be all setup.
    Is there any trick to get it to work?
    (curious if there are any dependencies from Java version in use…)

    thanks,
    Oleg.

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
          1. yes, Im connected to DB. (no I dont have HR schema, but have a bunch of others which I have full access to; migrating from TOAD, where this feature was working fine…)
            to be exact, Im using:
            Oracle DB ver. 10R2, driver ver.11.2.0.1/32bit.

          2. thatjeffsmith Post
            Author
  5. Hi Jeff,

    I intended to mention the same bug, Jad already did.
    Hope drag and drop functionality comes back in the next version, it’s one of my favourites!

    Happily there’s still plenty of functionality that compensate this little bug by far.

    Regards Henry

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *