I am using Oracle SQL Developer 20.2.0.175.

I have the table X with a numeric field and a VARCHAR field.

X_IDIOMA     NOT NULL NUMBER(2)          
X_DESC_CORTA          VARCHAR2(6 CHAR)

I do select * from x;

Then, I export the results to clipboard.

The problem is, I get the X_IDIOMA field, that is a number, exported with quotation marks.

Insert into X (X_IDIOMA,X_DESC_CORTA) values ('1','FRIES');

I would like to export the numeric fields, without quotation marks, like this:

Insert into X (X_IDIOMA,X_DESC_CORTA) values (1,'FRIES');

I have been researching, and I can’t find the option I should modify on the settings, so quotation marks are no added to the number fields when exporting a table.

I have been looking at the settings:

What option should I modify so number fields are exported as a number without quotation marks?

Using a different version of sql developer would be hard since I can’t add any software.