Enhancement request: Copy SQL to Clipboard

[nmajdan]

I frequently run queries and save the results as a SQL file. I wish there was another option in addition to "Export Results -> SQL File" to either export the SQL (as inserts) to either the clipboard or to another SQL Window.

 

[D.]

This was scheduled for an enhancement in 8.0 ???
(see this topic )

Is this ever going to get developed? Been asked for several times now, and was even scheduled for inclusion in 8.0 release. What happened ?

D.

 

[Marco Kalter]

I guess it did not have the right priority assigned. I have corrected this, so you can look forward to this feature in an upcoming release.

 

[nmajdan]

Thanks guys!

Something to add to this. It would also be nice if there was an option to suppress columns that are null.

For example, if I have a table like this:

TBL_EXAMPLE
COL_A  COL_B  COL_C
------ ------ ------
AlphaA AlphaB AlphaC
BetaA         BetaC

And I do a select like this:

SELECT * FROM TBL_EXAMPLE WHERE COL_A='BetaA';

Currently, if I choose the export to SQL option, I get an insert like this:

INSERT INTO TBL_EXAMPLE (COL_A, COL_B, COL_C) VALUES ('BetaA', NULL, 'BetaC');

What I am proposing would suppress the nulls so the insert would look like this:

INSERT INTO TBL_EXAMPLE(COL_A, COL_C) VALUES ('BetaA', 'BetaC');

I am requesting this because on wide tables, having all the unnecessary nulls really wastes a lot of space. I am fairly new to the PLSQL Developer world as my previous company used TOAD and this was something TOAD did that PLSQL Developer does not.

 

[Gustavo]

Please note, though, that these commands will not behave the same way if your null columns have default values. I think this is a problem in TOAD and that null columns should NOT be suppressed.