Constraints in Schema Browser
It's important to see all constraints under MySchema and not only in the TAB of ObjectInspector of a table
Browse Popular Ideas
-
This idea is active.Schema Browser »Add your comment
-
This idea is active.Connections »
Connection in Schema Browser
When there are multiple connections it seems difficult to know what connection the schema browser is using. Possibly add a connection option ...more »
Add your commentWhen there are multiple connections it seems difficult to know what connection the schema browser is using. Possibly add a connection option to the schema browser view similar to what is in the session browser.
« less full details »
-
This idea is active.Schema Browser »
Right click and run procedure.
If there is a way where we can Right click on the procedure or function and Run and view the Out parameters values, then it will make this plugin ...more »
Add your commentIf there is a way where we can Right click on the procedure or function and Run and view the
Out parameters values, then it will make this plugin really great.
Now its only useful for SQL Queries
« less full details »
-
This idea is active.
-
This idea is active.Data »
Open up appropriate file editors for blob columns, if content ca
Often, BLOB columns are used to store files, such as images, movies, PDFs or any other type of binary data. Sometimes, those binary streams start ...more »
3 commentsOften, BLOB columns are used to store files, such as images, movies, PDFs or any other type of binary data. Sometimes, those binary streams start with some pattern that makes it easy to recognise the file type, e.g. images, or PDFs. For the most common file types, it might be useful to directly open the OS's default editor to view the BLOB's content
« less full details »
-
This idea is active.Editor »
Show Owner on Stored Procedures
Show object owner when editing stored procedures just like the describe object window of a table/view allows you to do when looking at the script ...more »
1 commentShow object owner when editing stored procedures just like the describe object window of a table/view allows you to do when looking at the script tab.
« less full details »
-
This idea is active.Other »
Support MySQL
Add your commentSince apparently the plugin can support connections to multiple database engines, it would be fantastic if MySQL would be supported.
-
This idea is active.Settings »
ask to open files from disk in stored procedure editor
Currently files from disk are generally opened in SQL script editor. But most of my files hold stored procedures (packages to be exact). When ...more »
2 commentsCurrently 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 »
-
This idea is active.Connections »
Sort connections alphabetically and group by database.
Add your commentSort connections alphabetically and group by database.
-
This idea is in review.Connections »
Support for Proxy for individual connections
Add support for proxy for individual connections beacause of work safety- e.g. when I have several different socks-proxies in order to reach ...more »
3 commentsAdd 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 »
-
This idea is active.Schema Browser »
Add possibility to have multiple comma-separated filters in the
Sometimes, I'd like to find all objects in the schema browser containing *FOO* or *BAR*. It would be useful to be able to filter for *FOO*,*BAR* ...more »
Add your commentSometimes, I'd like to find all objects in the schema browser containing *FOO* or *BAR*. It would be useful to be able to filter for *FOO*,*BAR* or any similar combination. The killer feature for nerds like me would be regular expression search, of course :-) But I think comma-separated expressions will do the trick for most users
« less full details »
-
This idea is active.Editor »
convert '?' to bind parameter ':Bn' when converting to SQL
When Converting a String from another language to SQL automatically convert question marks (?) to SQL bind variables (:Bn with n = integer number). ...more »
1 commentWhen 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
« less full details »
-
This idea is active.Schema Browser »
compare schema tab
Add your commentI suggest you put compare schema tab on plugin. because in my job we used more it. thank you.
-
This idea is active.Data »
Add support for TABLE / VARRAY types
When selecting from tables that contain TABLE / VARRAY types, the SQL Worksheet's output simply displays a toString() version of oracle.sql.ARRAY. ...more »
Add your commentWhen 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
« less full details »
-
This idea is active.Editor »
remember file an object was created from
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 ...more »
Add your commentIn 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
« less full details »
-
This idea is active.Schema Browser »
Support Oracle UDT member procedures and functions
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 ...more »
Add your commentIn 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 »
-
This idea is active.Editor »
show comment of procedure/function
Add your comment
I suggest you... strip the header comment of a procedure/function and show it in the mouseover hover.
bye
T
-
This idea is active.Connections »
Addition session features
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 ...more »
Add your commentIn 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.
« less full details »
-
This idea is active.Other »
SQL Script for MVW
Add your commentI need to see the SQL Script for created Materialized Views in a tab of object describer as in tables or views.
-
This idea is active.Schema Browser »
Performance regression tests
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 ...more »
Add your commentWith 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?
« less full details »
-
This idea is active.Data »
Allow for opening several data tabs
When I click on a table/view/package, etc in the Schema Browser, the object is always opened in the same tab. The integration with the Eclipse ...more »
2 commentsWhen I click on a table/view/package, etc in the Schema Browser, the object is always opened in the same tab. The integration with the Eclipse editor history is well-done, I can easily navigate back and forth. But often, I'd like to open two data tabs at the same time. Many applications implement this using Ctrl-Click. This action could also be made available from the context menu.
« less full details »
-
This idea is in review.Other »
Move option to add toad nature from project's context menu root
Add your commentSimilar issue in spring ide tracker: https://jira.springsource.org/browse/IDE-1183
-
This idea is active.Schema Browser »
add partition support
Add your comment
please add support of paritions (mark partitionned tables in schema browser and show partition information in table detail page)
-
This idea is active.Editor »
Add delay to syntax check
Sometimes, syntax checking can be a bit slow, especially when large packages are edited. It might be useful to add a little delay to the syntax ...more »
Add your commentSometimes, syntax checking can be a bit slow, especially when large packages are edited. It might be useful to add a little delay to the syntax checking Job (which can be seen in the Eclipse Progress view) in order to avoid syntax checking when typing fastly.
E.g. when hitting two keys within 100ms, don't check the syntax after the first keystroke. Or in other words, only check syntax when the editor was idle for at least 100ms / 200ms / some configurable value...
« less full details »
-
This idea is active.Editor »
Allow for toggling comments / block comments
In many Eclipse editors, I can select a block of code and execute a "toggle comment / block comment" action on the selection. This is very useful ...more »
Add your commentIn many Eclipse editors, I can select a block of code and execute a "toggle comment / block comment" action on the selection. This is very useful and I'd love to see that in the SQL Worksheet, as well as in TEE editors too.
See a screenshot here:
« less full details »
Social Web