Feature Request: Ignore NULL-Values when exporting Result Set as Insert Statement

[Uwe]

Hello Marco,

we use very broad tables with sparse data (better don't ask why ).
When exporting the data as Insert Statements I get 80-90% NULL values.
I really would appreciate if there was a way to ignore the NULL columns in the statements.

Regards
Uwe

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Maxmix]

Additionally, it would be nice if PLSQL Developer did not include ROWIDs in Insert statements. This happens when we do 'Export results | SQL file' from the result grid:

insert into BRANCHS (CODE, MBR_ID, IS_CESSIONARY, ACTUAL, ROWID)
values (70, 3218, 'N', 'Y', 'AAAMp2AAEAAAAGYAAP');

prompt Done.

 

[Gustavo]

Interesting... I never get the ROWID.