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.
- 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.
- 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.
- 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
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!
Yes I know.
I think you will like the answer, very very very soon.
Thanks Jeff. I’ll keep an eye out for the MCP announcement.
I appreciate you for taking the time to answer the question..and thank you for the tip.
Of course, any time!
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.
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