Do you have an idea to improve Toad Extension for Eclipse? We want to hear it! Idea Pond is a site where you can tell the development team what you want, and tell us how important it is by submitting, voting, and commenting on ideas. Just sign in and submit your idea in the box below.
Idea Pond is just for submitting enhancement suggestions. If you need help or found a bug, please join our forums for assistance. See our FAQ for more information about Idea Pond.
Open a SQL file in SQL editor Instead of import. Like that instead of export, i want to keep my sql in file itself and open that in SQL editor and run the query. when i press Ctrl + S, it should save the changes in that file itself.
I may forget to export my sql. that time i loss my SQL.
I suggest you put compare schema tab on plugin. because in my job we used more it. thank you.
When I close a connection, all associated/connected SQL Worksheets are closed, too. That means I have to save all SQL to the clipboard or elsewhere before closing the connection.
Instead, the SQL Worksheets should simply be "disconnected"
Add possibility to record macro and assign shortcuts to macro. Macro should have the ability to work with current selection. In such case, the following macros can be recorded (for example) Preview table select * from $SELECTION$ limit 10 Count rows in table select count(*) from $SELECTION$ Drop table drop table $SELECTION$; Get all tables with selected string in name (postgresql syntax) select table_schema, table_name, ...more »
Add possibility to record macro and assign shortcuts to macro. Macro should have the ability to work with current selection. In such case, the following macros can be recorded (for example)
Preview table
select * from $SELECTION$ limit 10
Count rows in table
select count(*) from $SELECTION$
Drop table
drop table $SELECTION$;
Get all tables with selected string in name (postgresql syntax)
select table_schema, table_name, table_type from information_schema.tables where table_name like '%' || '$SELECTION$' ||'%' order by table_name
This feature is implemented in pgAdmin.
« less full details »
When editing a package body, it would be useful if the outline would distinguish objects between "public" ones (declared in the package specification) and "private" ones (declared only in the package body).
With 400+ views and 100 packages with lots of stored procedures, starting up a connection is very very slow. Along with the blocked UI thread reported by robert.munteanu, this can get quite annoying. The current performance issue is already filed in the forum, but the idea here is to have performance regression tests against several large test schemata, maybe with tools from dynaTrace?
Allow to export/import of connections in Toad Extension for Eclipse. Allow to configure connection naming pattern in preference page such as 'DB_USER' instead of default to 'USER@DB'.
Currently files from disk are generally opened in SQL script editor. But most of my files hold stored procedures (packages to be exact). When opennig a file ask which editor shall be used and remember this decision per file. In this case when hitting the "show Package [Body]" button ask for the file to load rather than openning it from the DB. Please also provide a preferences option to define name patterns (or paths) ...more »
Currently files from disk are generally opened in SQL script editor. But most of my files hold stored procedures (packages to be exact).
When opennig a file ask which editor shall be used and remember this decision per file. In this case when hitting the "show Package [Body]" button ask for the file to load rather than openning it from the DB.
Please also provide a preferences option to define name patterns (or paths) for files containig stored procedures rather than scripts.
bye
T
« less full details »
When writing stored procedures, I'd like to use Javadoc-like block comments to document procedures, parameters, return values, etc. This seems to be a common practice anyway:
http://pldoc.sourceforge.net/maven-site/
I'd love it when TEE were capable of handling these documentation elements a bit better:
* Auto-completion
* Auto-indentation
* etc...
Having the option to extract data from a tebela generating a script to insert the values already existing in the table or select one based on generating inserts "Extract data based on a bullshit and your data or your data and select one returned" example: table person describ insert into person (id, name) valeus (1, 'richads') / insert into person (id, name) valeus (2, 'Madonna') / insert into person (id, name) ...more »
Having the option to extract data from a tebela generating a script to insert the values already existing in the table or select one based on generating inserts "Extract data based on a bullshit and your data or your data and select one returned" example:
table person describ
insert into person (id, name) valeus (1, 'richads')
/
insert into person (id, name) valeus (2, 'Madonna')
/
insert into person (id, name) valeus (3, 'Joy')
/
« less full details »
Add support for proxy for individual connections beacause of work safety- e.g. when I have several different socks-proxies in order to reach different databases, and I would like an option to specify which socks-proxy to use for each database-connection. As it works now, I have to set up static tunnels through the different proxies, and make every connection to localhost. This is a bit unsecure, since I can actually switch ...more »
Add support for proxy for individual connections beacause of work safety- e.g. when I have several different socks-proxies in order to reach different databases, and I would like an option to specify which socks-proxy to use for each database-connection.
As it works now, I have to set up static tunnels through the different proxies, and make every connection to localhost. This is a bit unsecure, since I can actually switch production and test-dabase on my tunnels and then believe I'm working on test, when in fact working in production.
« less full details »
When there is a connection timeout, TEE could try to reconnect with the previous parameters of the connection. Of course, this should be done carefully, i.e.
- not blocking the UI thread
- not trying to connect 100 times per second. maybe, always double the wait-interval between automatic re-connect attempts
When I lose and regain my network I will sometimes getting the dialog "java.sql.SQLRecoverableException: Closed Connection" with title "SQL Error" I click OK and it comes up again and again. I have to hard kill Eclipse for it to go away. When the error is up I can't use Eclipse at all.
When Converting a String from another language to SQL automatically convert question marks (?) to SQL bind variables (:Bn with n = integer number).
Currently question marks are preserved and lead to errors on statement execution.
bye
T
please add support of paritions (mark partitionned tables in schema browser and show partition information in table detail page)
I really miss the debug functionality in the Toad extension. It makes the plugin useless for some more serious PL/SQL scripts. Any chances for it?
When selecting from tables that contain TABLE / VARRAY types, the SQL Worksheet's output simply displays a toString() version of oracle.sql.ARRAY.
It would be nice if those arrays could be displayed somehow, e.g.
In tables shortened with Ellipsis ... : [1, 2, 3, 4, 5, ...]
When double-clicking, the full data is displayed
Currently, the outline is always linked with the Editor. Sometimes, this is not desireable, though. Please add a "Link with Editor" button, which is quite common in Eclipse views
In case a DB-Object has been creates from a file or was saved to a file remember that name and location so that the save dialog can be initialized with that path.
bye
TPD
In Oracle, a UDT can declare member procedures and functions. An example can be seen here: http://www.adp-gmbh.ch/ora/plsql/oo/member.html Oracle documentation can be seen here: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjbas.htm#i477669 Currently, TEE allows for viewing the type specification and body as text, which is good. If this is possible by querying the dictionary views, I think it ...more »
In Oracle, a UDT can declare member procedures and functions. An example can be seen here:
http://www.adp-gmbh.ch/ora/plsql/oo/member.html
Oracle documentation can be seen here:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjbas.htm#i477669
Currently, TEE allows for viewing the type specification and body as text, which is good. If this is possible by querying the dictionary views, I think it might also be a good idea to list member functions and procedures explicitly in the schema browser and maybe provide means to edit them explicitly (not the whole type body). But maybe that's not possible...
**UPDATE**: Method declarations are available from SYS.USER_TYPE_METHODS. Method arguments are also in SYS.USER_ARGUMENTS...
« less full details »
I suggest you... strip the header comment of a procedure/function and show it in the mouseover hover.
bye
T
I have a lot of objects that start with the same prefix. This way I have to type a lot of characters before code completion is really a benefit. I suggest an "camel case like" proposal finder for code completion: This is the rule: lowercase letters match exactly. uppercase letters mach behind the next underscore within an object name. example: MTT and myTeT both match 'MY_TEST_TABEL_NAME', but myTeT does not match ...more »
I have a lot of objects that start with the same prefix. This way I have to type a lot of characters before code completion is really a benefit.
I suggest an "camel case like" proposal finder for code completion:
This is the rule:
lowercase letters match exactly.
uppercase letters mach behind the next underscore within an object name.
example:
MTT and myTeT both match 'MY_TEST_TABEL_NAME', but myTeT does not match MY_TABLE_TEST_NAME while MTT does.
bye
T
« less full details »
In the Session View add current SQL for the session. Also, it would be great to have a way to see locks to see what sessions are blocking each other.
I need to see the SQL Script for created Materialized Views in a tab of object describer as in tables or views.
In the sessions view allow start/stop traceing the selected session.
Social Web