Ask A Question

Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!

If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!

Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.

Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.

  1. I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
  2. I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
  3. I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.

Go!

7,987 Comments

  1. Robert Boucher Reply

    Hi Jeff, I was wondering if you knew if there is an (official) effort at Oracle to create a model context protocol (MCP) server to allow Gen-AI enabled tools like VS Code to be context aware of Oracle databases? Thanks!

    • Robert Boucher

      Thanks Jeff. I’ll keep an eye out for the MCP announcement.

  2. Peter Drahos Reply

    I appreciate you for taking the time to answer the question..and thank you for the tip.

  3. Peter Drahos Reply

    Hi Jeff,
    I started using the extension 25.1.1 recently and connected it to EBS 12.2.14, while I can use sql worksheet and run queries I am not having any success populating the object tree, should this be working or is there a trick to it. I am wondering if the reason is the amount of data that needs to be pulled in for browsing through the objects. Every presentation on line that I saw is using a simple DB, just not with number of items EBS database contains.
    Thank you
    Peter

    • We don’t care how ‘big’ your database is.

      We’re querying the dictionary for objects, and it tells us what is there.

      You can see the queries we’re running in the Output panel, with category switched to SQL Developer Log. In Extension preferences, set the extension logging to ‘TRACE.’

      We’re basically querying the contents of the ALL_ views like ALL_OBJECTS, ALL_TABLES, etc.

    • Peter Drahos

      never mind sorry about that, I figured it out after going into Other Users and then applying filter, it works as would expect. I need little more time discovering the tool.
      Thank you

Write A Comment