Oracle SQL Developer: The Definitive Guide to Completion Insight

thatjeffsmith SQL Developer 7 Comments

Tell Others About This Story:

Can SQL Developer help me finish my SQL or code?

Probably.

Here’s a quick showing of what it’s capable of.

Start typing a table name...

Start typing a table name…

Get a list of columns...

Get a list of columns…

Get a list of joins...

Get a list of joins…

Columns available in a predicate...

Columns available in a predicate…

What does this procedure need to be invoked?

What does this procedure need to be invoked?

What about this procedure?

What about this procedure?

OK, just print it out for me already!

OK, just print it out for me already!

Mouse over the grammar squiggle for the help

Mouse over the grammar squiggle for the help

Let's do that again...

Let’s do that again…

Need more help on the syntax? Click on the keyword in the last two examples, and you’ll be taken to Oracle DOCS syntax pages for that command.

Update: I Found One More!

plsql variables and datatype labels

plsql variables and datatype labels

Not working?

A few things to remember:

  • mind the preferences – delay timers, automatic off, limiting the help based on # of hits
  • if the insight query takes too long, the help won’t get printed
  • the helper is invoked with ctrl+spacebar (Mac & Windows)
  • the better grammar you use, the more luck our parser will have in figuring out what you’re doing or what you’re talking about

Just watch the movie

Tell Others About This Story:

Comments 7

  1. For some reason Completion Insight on a SQL Worksheet works in two of our environments, but not our other two. It does not work with Auto-Popup or using Ctrl-Space. I understand there are two connections. One that is used for Insight, but don’t see where I can check or verify. I have tried enabling and disabling Auto-Popup. Nothing seems to work. If I get frustrated and press Ctrl-Space many times, then when I try to run a SQL statement, it can take a very long time. Any ideas on what I can do to get it working for the two environments?

    1. thatjeffsmith Post
      Author

      So…what’s different between the two environments?

      In newer versions of SQLDev, you can see us fire off the insight queries and see the execution times in View > Log > Statements.

      1. I am not seeing that option. I have Version 4.1.5.21. I only see “Messages – Log”.

        I was able to resolve the issue by “resetting” SQLDev.
        Exited SQLDev
        Go to C:\Users\eric\AppData\Roaming. Replace “eric” with your userid (for Win7)
        Rename/backup directories “SQL Developer” and “sqldeveloper”.
        Restart SQLDev

        You will need to redo your connections, preferences, …, but it addressed the problem for me.

        Here is a link to your reset SQLDev page:
        http://www.thatjeffsmith.com/archive/2015/08/how-to-reset-your-sql-developer-preferencessettings/

        Thanks for your help AND this site!!

  2. Hi, Jeff, is possible to change order the result list in prompt for Completion Insight?, because when I use this, the order is alphabetical ascending and I need that it shows like command DESCRIBE. The real order in the table and not alphabetic.

    1. thatjeffsmith Post
      Author
  3. Jeff, does SQL Developer have the ability to autocomplete function/procedure names when referencing another package? For example, in package “a”, I’m calling a procedure named “helloWorld” from package “b”. When I type “b.”, I would love for a list of the procedures/functions available in that package. Is this possible?

    1. thatjeffsmith Post
      Author

Leave a Reply

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