features request

[shayt]

hi,
as a new user in PLSQL Developer,
i want to say that this tool have many advantages on other tools.

but, a few things are missing -
1. i want to copy the header of a column (in the output grid) by right click on the column, and then choose copy header, or if i am right click on the header itself, then choose copy.

2. SQL window (not Test window), does NOT support bind variables. i know test window support it (very good i must say), but i want to write multiple queries and run only one of them (with bind variables)

3. export as "insert into" lines

4. in the explain plan, i need to know if a table is NOT analyzed (and if not, press a button to analyze it)

5. maybe i don't know how to do it, but i didn't succeed doing the following in SQL/Test windows :
DELETE x
/
DELETE y
/

6. Fetch - when i do select with many results, the fetch gives me a page, and i need to press a button to get more results. i want to have the same behavior like SQL Navigator - i will get a page, but if i do page down, it will give me more results.

7. and a small suggestion - please improve the GUI.

Thanks, and have a nice day.
Shay

 

[ScottMattes]

2. change all ':' to '&'

5. If you want to execute multiple statements use the Command Window, otherwise replace '/' with ';' and go to Tools / Preferences / Window Types / SQL Window and check AutoSelect statement - then just press F8 to execute the statement you are on.

7. careful, your 'improve' might not be what Allround's idea of 'improve' is. how would you like to see it changed?

 

[Marco Kalter]

3. This is possible via the "Export Tables" tool. You could also write an Export Plug-In.

I have added your other suggestions to the list of enhancement requests.

 

[shayt]

Originally posted by ScottMattes:

5. If you want to execute multiple statements use the Command Window, otherwise replace '/' with ';' and go to Tools / Preferences / Window Types / SQL Window and check AutoSelect statement - then just press F8 to execute the statement you are on.

7. careful, your 'improve' might not be what Allround's idea of 'improve' is. how would you like to see it changed?

about #5 -
this is not what i ment, i want to run ALL the commands in one time (as script),
so this is why i seperate each of them with ";" or "/".
i want to mark all the relevant lines, click F8, and all the commands will be executed.
of course i am not talking about SELECT command, in the script there are just insert/delete/update/create/ commands.

about #7 -
well, many programmers in my company look at a few tools, and everybody agree that the GUI is lacking (graphics), so just think about it for the future...

thanks,
Shay

 

[D.]

Originally posted by shayt:

about #5 -
this is not what i ment, i want to run ALL the commands in one time (as script),
so this is why i seperate each of them with ";" or "/".
i want to mark all the relevant lines, click F8, and all the commands will be executed.
of course i am not talking about SELECT command, in the script there are just insert/delete/update/create/ commands.

Use the command window for this type of execution. Works similar to a SQL*Plus session.

Regards,
D.