Already pretty good, and in many ways better than the old SQL Developer. This is a list of the things that I've noticed using it every day for the past few months, some of which keep me from fully switching.
Wish list:
- DB diff
- Custom code templates
- Coloring null values in query result
- Pin query result
- Session monitor
- Option to always open package body or spec on "Go to declaration"
- Option to not automatically open package details when opening a package
- Option to disable autofit. It causes additional lag when running a query or scrolling the results. Also if a query returns a single number column, the column stretches across the entire screen and the result ends up in the far right corner. In legacy this worked much better.
- When opening a worksheet, tab name should default to database name like in legacy
- Explain plan option when right-clicking a query
- Autocomplete for columns (for example in WHERE or ORDER BY)
- Pretty print option when exporting query results to JSON
Issues:
- When a cell is selected in query result (to be copied for example) it is hard to see the selected cell in dark mode
- If there are multiple packages with the same name in different schemas "Go to declaration" shows a list that i then have to pick from, while the legacy SQL Developer would open the one from the current schema
- When i leave a worksheet open and come back the next day, i shouldn't have to manually reconnect and reattach connection. In legacy this was automatic
- Sometimes after executing a query the worksheet losses focus so you have to click on the query again
- Typing "OR" should not autocomplete to ORA_ROWSCN
- Autocomplete doesn't show system views/tables like USER_OBJECTS, and sometimes fails to autocomplete procedures
- Go to declaration for a global function does not work inside packages
- Can't select multiple cells in query result (for copying) like you could in legacy
- If multiple columns have the same name (no aliases), JSON export to clipboard gives invalid JSON
- Typing "WITH XXX AS (" autocompletes to ADD_MONTHS
- When compiling a procedure fails due to an invalid "AFTER CREATE ON SCHEMA" trigger the changes are erased