Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Results Grid Feedback

JasonBatzlaffJan 18 2024

First off - thanks for creating the new tool. I am excited to begin using these new features. The hard work of the team is appreciated.

My most typical use case is not abnormal. I run queries all the time. So my initial feedback has to do with how the Query Results grid functions. Perhaps there are settings for some of these issues I note below.

Most of these are apparent differences from how I have come to know SQL Developer (or other Grid-based applications) to work

  • Headings for columns are truncated to fit in screen. Need to use right-click > Auto-fit All Columns > On Header each time to fix.
  • Cannot select multiple single cells (via mouse or keyboard). For example click and drag to select cells. Or select a single cell and use keyboard and SHIFT key to navigate through cells. One would expect the cells to be selected and become payload for a copy-paste routine.
  • Selecting a heading does not select the data in the column
  • Unable to use Ctrl-A in Grid to select all grid content. Typically use Ctrl-A, Ctrl-C to pull information quickly to paste elsewhere. When clicking Ctrl-A, all text on the page is selected (including the time to execute the query)
  • Selecting row number (column 1 of grid) selects the row. Clicking another row retains the original selection - similar to how I would assume a [ctrl] + [row select] would work - but I didn't click the ctrl key. Not intuitive for each successive row to remain selected. Not sure how to clear these selections besides re-running the query or unselecting the rows

Export:

  • Export: Cannot export straight to clipboard. In SQL developer, this is a "Save As" preference
  • Export: No preferences to set the default Format setting for the export. Reverts to CSV each time. I typically used Tab Delimited with Save As = Clipboard. This allowed my “export” to easily paste into a spreadsheet. I usually paste into an existing spreadsheet – as opposed to creating a new file for every export.
  • Export: No default location to save files. Continously reverts to User Home directory each time I try to export even though my last save was to a different location.
  • Export to Excel: Best feature of exporting to Excel was the automatic “Data” and “SQL” tabs.

Thanks,

Jason

Comments
Post Details
Added on Jan 18 2024
25 comments
1,137 views