Feature suggestion: Copy SQL to Clipboard As...

[expired user #8628]'s profile image [expired user #8628] posted 9 years ago in Feature discussion Permalink
I would love to see a feature like "Copy SQL to Clipboard As..." or "SQL special copy..." as I know it from Allround Automations PL/SQL Developer.
In PL/SQL Developer this feature allows you to copy the selected statement into the syntax of VB, Java and other programming languages.

The clipborad SQL include all brackets, line returns and format special characters.
This feature comes pretty handy when developing or maintaining programs with in-code queries (e.g. JPA named queries, 90s VB6 programs).

Currently I open the PL/SQL Developer, paste MySQL, PosGreSql, Sql-Server SQLs and let PL/SQL Developer format it.

It would be nice if it would be possible to avoid this step with the feature requested.

Kind regards, Marcus
ansgar's profile image ansgar posted 9 years ago Permalink
Did you try out the "Export grid rows" feature? When you have a result, right click it, then click "Export grid rows" and see you can copy rows as "SQL INSERTs" and "SQL REPLACEs".
[expired user #8721]'s profile image [expired user #8721] posted 9 years ago Permalink
that would be nice. because of the current behaviour, it is not possible to use encrypted key files with heidisql, which i would prefer to do for security reasons.


HyBriDe Dd
[expired user #8628]'s profile image [expired user #8628] posted 9 years ago Permalink
Hi, sorry for the delay (I was travelling).

Probably you misunderstood my suggestion. So I attached screenshots to this post.

The first screehshot is a SQL statement with linebreaks and indents.
When marked, the statement (not the result!) can be copied to the clipboard.
Various programming languages are supported for formatting.
The outcome (when pasted in an editor) is the language specific formatted (pretty-printed) SQL.

But pictures say more than a thousand words. The screenshots should be self-explanatory.
1 attachment(s):
  • special-copy

Please login to leave a reply, or register at first.