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!
8,222 Comments
I want to thank you for keeping afloat the legacy version of sqldeveloper. It’s still the best one available.
My name is Timothy Sharpe, and I’m a database developer with over 30 years of professional experience working with SQL Server, Oracle, and PostgreSQL.
Over the past several years I’ve developed an open-source project called Easy Pivot that automatically generates complex pivot SQL from a simple declarative specification. It began as a SQL Server project and has since expanded to PostgreSQL and Oracle.
While implementing the Oracle version, it occurred to me that the underlying algorithm might fit naturally into Oracle SQL Developer as a developer productivity feature.
Rather than manually constructing lengthy PIVOT queries, a developer could select a source query, identify grouping columns, pivot columns, aggregate functions, and sort preferences, and SQL Developer could generate the Oracle SQL automatically while still allowing the developer to inspect and modify the generated code.
Has Oracle ever explored this type of workflow for SQL Developer?
If not, I’d be interested in sharing a short executive summary of the concept. Easy Pivot itself is open source and will remain free. My interest is simply in contributing an idea that I believe could make Oracle developers more productive.
Thank you for your time.
Timothy David Sharpe
https://github.com/pivot-my-stuff/easy_pivot
Not sure this counts as a question…
In the stand-alone SQL Developer, there is a ‘Toggle ANSI/Oracle Joins’ feature. Is this available in the VSCode extension version?
No/Not yet
Is there a way to get my huge, old sql history from sql developer (legacy) to the sql history of the vs code extension? I found both directories, but the file structure seems to be different and needs to be converted. Is any migration/import script available?
No, but like you said, you have the two files. You could use an AI/LLM to generate some Python to do that conversion for you.
Hi Jeff,
I’m trying to figure out whether the SQL Developer VS Code extension supports debugging PL/SQL from APEX applications.
The classic Oracle SQL Developer uses JDWP for PL/SQL debugging:
https://www.slideshare.net/slideshow/debugging-plsql-from-your-apex-applications-with-oracle-sql-developer/146095763
Does the SQL Developer VS Code extension already support this feature?
Finally moving from SQL Developer Version 24.3.1.347 to VS Code with the SQL Developer Extension. And I see your post from Jan. 2026 about canned reports being available. My question is: what about user reports? Will that be added or is there another way to do user reports in VS Code with the SQL Developer Extension?
We’re going to enhance the SQL Notebooks to offer what User Defined Reports used to.