How to Include Borders in SQL Developer Query Results When Copying

Discover a simple method to `export SQL Developer query results with borders` for better readability and presentation. Learn step-by-step instructions here!
---

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How do you include the borders in the query result when copying?

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Include Borders in SQL Developer Query Results When Copying

If you're working with Oracle’s SQL Developer and often need to share query results, you may have noticed that copying the data directly from the query results often removes necessary table borders. This can lead to a confusing presentation of the data, especially when sharing it via email or other mediums. But fear not! Today, we'll explore an easy way to achieve clean, bordered results from your SQL Developer queries.

Understanding the Problem

By default, when you copy data from the SQL Developer query results, it doesn't include any table borders. This limitation can make it hard to decipher where one piece of data ends and another begins. If you're looking to present your results in a clear and professional manner, adding borders is crucial.

The Solution: Exporting Query Results

While SQL Developer doesn’t allow direct copying of bordered results to the clipboard, you can achieve your desired outcome through a few simple steps. Here’s an organized guide to help you through the process:

Step 1: Export the Query Results

Right-click on the data grid in the query result window.

From the context menu, select "Export...".

In the Export dialog, configure the following settings:

Format: Choose HTML.

Save as: Select Single file.

Step 2: Open Your Exported File

Navigate to the destination folder you selected earlier (e.g., C:\temp).

Step 3: Copy the Results

Once the HTML file is open, use Ctrl + A to select all the contents.

Press Ctrl + C to copy the selected items to your clipboard.

Open your email client or any application where you want to paste the results.

Use Ctrl + V to paste the clipboard contents.

Step 4: Set Borders (If Necessary)

If you're pasting into an email client that allows for formatting, you may need to select the entire HTML table and set the borders manually to enhance visibility.

Conclusion

While SQL Developer lacks certain functionalities like direct clipboard export with borders (a feature found in tools like TOAD), the method outlined here is straightforward and effective. By following these four steps, you can easily export and share your query results with clear formatting, ensuring your data is easily read and understood.

Remember, presentation matters, and having well-formatted data can significantly improve the communication of your results.

Feel free to share this guide with colleagues who may also benefit from a more organized way to present SQL Developer export results!