SQL Developer Only Copies Part of Query Results When Using The Copy Command (Doc ID 3006458.1)

Last updated on FEBRUARY 23, 2024

Applies to:

Symptoms

On : SQL Developer Version 23.1.1

SQL Developer only copies part of results of query when using the copy (CTRL-C) command.

For Example:

Run a query. When try to copy the results/output to an Excel spreadsheet or Notepad, the Copy command (CTRL-C) only copies some of the rows, not all.
However, this does not happen with all tables/queries.

After some analysis, it appears to be truncating at a special character [chr(00)] that is embedded in some of the column records.

For example, if the output of the query is:

column1         column2           column3
------------------------------------------------------------
1                  test              This is a chr(00) test.
2                  test2            This is another test.

And you try to copy both records by selecting them, doing Ctrl-C, and pasting them in Notepad or Excel, it will only show:

If the chr(00) does not exist, then it would show:

This does not reproduce from other tools, like Toad or SQL*Plus.

 
EXPECTED BEHAVIOR
Need to be able to copy/paste all selected records.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.