Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

Video: Completion Insight in Oracle SQL Developer v4.0.2

1 Min Read

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.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

15 Comments

  1. Piyush Singh Reply

    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

  2. Carlo Reply

    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.

  3. Oleg Reply

    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. Oleg Reply

    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.

    • thatjeffsmith Post Author

      No dependencies on Java. The tricks are not to confuse the parser.

      So, in a completely blank worksheet, try

      select * from hr. –> You should get a list of tables in HR.

      Does this work?

    • Oleg

      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.

    • thatjeffsmith Post Author

      You could try running SQL Developer in debug mode and capture the queries we’re running to populate those insight lists.

  5. Henry Reply

    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

Write A Comment