My Oracle Support Banner

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:

Oracle SQL Developer - Version 23.1.1 and later
Information in this document applies to any platform.


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:

1 test This is a

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

1 test   This is a chr test.
2 test2 This is another test.

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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