Dual Monitor Support
Dual (or More) Monitor Support with ability to move Schema Browser, Editor or other parts of Toad elements out of main window. The Undocked Layout as it used in Photoshop, Delphi etc.
Browse Popular Ideas
-
This idea is active.Monitor »25 comments for Idea: Dual Monitor Support
-
This idea is active.Editor »
Highlight keywords of branches (IF, THEN, ELSE...)
4 comments for Idea: Highlight keywords of branches (IF, THEN, ELSE...)
When I'm moving the cursor on IF, THEN, ELSE, ELSIF, END, please highlight all the other keywords of this branch.
-
This idea is active.Editor »
"Execute as script" to run in a thread
4 comments for Idea: "Execute as script" to run in a thread
If you execute a query using "Execute as script", all of TOAD locks up regardless of whether you have TOAD set to run in multiple threads. Is it possible to get around this?
-
This idea is active.Connections »
Better handling of disconnected sessions in TOAD
I'm not sure if this is a TOAD problem or an Oracle problem but its one I experience daily in TOAD. I often have multiple connections open in TOAD and I'll be jumping between them throughout the day. Often, the connection will be lost as I haven't used it for a while so I need to reconnect to the database, my problem is I don't know this until I have tried to do a refresh/change tab/execute procedure in TOAD. When ...more »
24 comments for Idea: Better handling of disconnected sessions in TOADI'm not sure if this is a TOAD problem or an Oracle problem but its one I experience daily in TOAD. I often have multiple connections open in TOAD and I'll be jumping between them throughout the day. Often, the connection will be lost as I haven't used it for a while so I need to reconnect to the database, my problem is I don't know this until I have tried to do a refresh/change tab/execute procedure in TOAD. When this happens its not unusual to get messages like:
Access violation at address 61CDF6A4 in module 'OraClient11.Dll'. Read of address 00000010.
I get lots of other ones too, sometimes offering me the Reconnect button, sometimes not. Often I get multiple messages. I often get them when I try to Test Connections (Reconnect) as well - lots of them.
I'm not sure, but I suspect, this is often a cause of crashes/hangs in TOAD or at least a loss of stability (again, often, once I've had these messages I'll keep getting them until I find them too annoying and restart TOAD), even after I've reconnected.
So, in summary, can we handle this better in TOAD? I know we can't "keep alive" our TOAD connections but can we better handle instances where we've tried to execute some code against a connection that's been dropped.
« less full details »
-
This idea is active.Editor »
Have new version of TOAD copy old version's formatter settings.
1 comment for Idea: Have new version of TOAD copy old version's formatter settings.When I install new version of TOAD, I would like you to copy my existing pl/sql formatter settings to the new version. For some reason I cannot get the new version to use my custom format settings even after I copied the .opt file to the new version.
-
This idea is active.Grid »
Enable Commit- and Rollback-buttons only at open transactions
3 comments for Idea: Enable Commit- and Rollback-buttons only at open transactionsI'd like to have an indication, a litte bit more eye-catching, when there's an open transaction after data-manipulation. So you could enable/highlight Commit- and Rollback-Buttons only when there's an open transaction.
-
This idea is active.Editor »
Highlight related INTO or VALUES text to enable easy matching
It would be very cool if TOAD would highlight matching INTO or VALUES text. For instance, if I have the following PLSQL: select 'this_value', 'that_value' into this_param, that_param from dual when the cursor is on THAT_VALUE it would also highlight THAT_PARAM. This would make it really easy to match up INTO values or VALUES in a INSERT INTO statement (I'm thinking for examples which are much bigger than my simple ...more »
5 comments for Idea: Highlight related INTO or VALUES text to enable easy matchingIt would be very cool if TOAD would highlight matching INTO or VALUES text. For instance, if I have the following PLSQL:
select 'this_value', 'that_value'
into this_param, that_param
from dual
when the cursor is on THAT_VALUE it would also highlight THAT_PARAM. This would make it really easy to match up INTO values or VALUES in a INSERT INTO statement (I'm thinking for examples which are much bigger than my simple example).
I'd also like it to highlight the entire block of code if the value is determined by a block of code i.e. a CASE statement.
Or maybe a hover over that displays the text. Lots of possibilities.
« less full details »
-
This idea is active.Other »
Make Toad open faster.
8 comments for Idea: Make Toad open faster.Make Toad open faster.
We pass from the version 9.1.0.62 to the 10.1.1.8.
The time to open Toad had very increase.
We are on XP Service Pack 3.
-
This idea is active.Other »
Show shortcut (key combination) in button hints
1 comment for Idea: Show shortcut (key combination) in button hints...so we don't have to look them up in Toad Options and get used to them faster.
-
This idea is active.Editor »
BLOCK SELECTION/EDIT MODE (Column Mode)
13 comments for Idea: BLOCK SELECTION/EDIT MODE (Column Mode)to enhace the editor (sql, pl/sql, text) with a "BLOCK SELECTION/EDIT MODE", as it's already availiable in Eclipse, OpenOffice, UltraEdit (there called "Column Mode").
-
This idea is active.Editor »
allow user cancellation of code completion
4 comments for Idea: allow user cancellation of code completionwhen I press a fullstop after a tablename toad can take forever to try and offer a list of columns. If we have network /database issues on that day this can take ages until it times out. Pressing escape key to cancel this would be great.
-
This idea is active.Editor »
View column position - easy identification
Easy way to match the column position in a view definition to the selected column. For large views, it is often difficult/time consuming to find out which column in the view definition corresponds to which column in the select statement. This usually involves counting its position in the definition and then counting down the same number in the select. Not a problem on small views but on some of the larger ones (particuarly ...more »
11 comments for Idea: View column position - easy identification
Easy way to match the column position in a view definition to the selected column. For large views, it is often difficult/time consuming to find out which column in the view definition corresponds to which column in the select statement. This usually involves counting its position in the definition and then counting down the same number in the select. Not a problem on small views but on some of the larger ones (particuarly in apps - mtl_system_items_vl selects 341 columns!) this can be an annoying and can often lead to picking the wrong column when the selected columns aliases don't correspond to the definition column names, or there are several subqueries.
I think a useful addition would be that if you place your cursor on a column alias in a view definition then by pressing some key (ctrl etc), the corresponding column/inline select is highlighted in the select statement.
eg:
CREATE VIEW v (c1,c2,c3,c4,c5) AS
SELECT x.y,x.z, a.b, a.c, a.d FROM t;
To, if I placed my cursor next to c3 above then something would indicate to me that a.c was the corresponding column. Perhaps colouring the background, highlighting etc...
« less full details »
-
This idea is active.Editor »
Speed Up Window Switching
5 comments for Idea: Speed Up Window SwitchingIs there anything that can be done to improve the performance when switching between windows within Toad. For example, within a connection, it seems to take several seconds to switch between and open editor session, and and open schema browser. I see the same performance issue just switching between open editor tabs.
-
This idea is active.Other »
Toad on Linux
4 comments for Idea: Toad on LinuxWould really like to see Toad run native on Linux - no wine, crossover office or virtual Window PC required.
-
This idea is active.Editor »
Show all of the first line of a folded code segment
In the pl/sql editor window when you fold code just the key word remains in pale grey. I think this would be more useful if the whole first line was retained so that it is easier to identify what code has been folded. For example instead of: CURSOR... You would see: CURSOR c_get_acc_dets IS... Still in pale grey so it's still obvious that it has been folded. Also although select, delete and inserts statements can ...more »
3 comments for Idea: Show all of the first line of a folded code segmentIn the pl/sql editor window when you fold code just the key word remains in pale grey. I think this would be more useful if the whole first line was retained so that it is easier to identify what code has been folded.
For example instead of:
CURSOR...
You would see:
CURSOR c_get_acc_dets IS...
Still in pale grey so it's still obvious that it has been folded.
Also although select, delete and inserts statements can be folded update statements can't. Please can this be included.
« less full details »
-
This idea is active.Other »
Choice for installer to un-install prev version while installing new version
This customer would like to have the choice, when installing a new version of Toad, to have the installer also un-install their previous version of Toad. Currently, when installing Toad, it installs it along side the old version and un-installing that old version is a manual task. The customer would like to be able to select something in the installer that asks if they want their previous version removed when installing ...more »
2 comments for Idea: Choice for installer to un-install prev version while installing new versionThis customer would like to have the choice, when installing a new version of Toad, to have the installer also un-install their previous version of Toad. Currently, when installing Toad, it installs it along side the old version and un-installing that old version is a manual task. The customer would like to be able to select something in the installer that asks if they want their previous version removed when installing the new version. Is this something we can do?
« less full details »
-
This idea is active.Other »
Better multi-Toad support
3 comments for Idea: Better multi-Toad supportSpend time getting multiple instances of Toad running better concurrently. There are issues with file access errors
-
This idea is active.Other »
View--> Full Screen
1 comment for Idea: View--> Full ScreenView-->Full screen please. I count 6 toolbars by default - overload of toolbars and tons of icons. Need a quick way to maximize viewing space.
-
This idea is active.Editor »
maintenance of named/personal SQL
make maintenance of personal/named SQL more intuitive. I mean, allow drag&drop adding new statements, drag&drop updating/replacing existing statements, pasting from clipboard, allow to do it through right-click menu and/or icons on local toolbar. now it is possible to do it just through main menu and as it is occasional operation I always tend to look for these possibilities directly in personal/named SQL window until ...more »
1 comment for Idea: maintenance of named/personal SQLmake maintenance of personal/named SQL more intuitive. I mean, allow drag&drop adding new statements, drag&drop updating/replacing existing statements, pasting from clipboard, allow to do it through right-click menu and/or icons on local toolbar.
now it is possible to do it just through main menu and as it is occasional operation I always tend to look for these possibilities directly in personal/named SQL window until I realize it is somewhere in main menu.
emha.
« less full details »
-
This idea is active.Debug »
Debug in simple plsql script
2 comments for Idea: Debug in simple plsql scriptImplemente debug in single plsql script.
In this moment to use debug, is necessary create one procedure like "lixo", to execute the debug
-
This idea is active.Idea Pond »
Be able to change vote
Add your comment for Idea: Be able to change voteBe able to change vote. Sometimes I may vote one way but then change my mind or I made a mistake. It would be nice to be able to change my vote.
-
This idea is active.Schema Browser »
XMLTYPE Editing - Schema Browser (Data Tab)
13 comments for Idea: XMLTYPE Editing - Schema Browser (Data Tab)I would like to see the XMLTYPE functionality from 9.7 re-implemented in to Toad. This functionality includes the ability to edit XMLTYPE fields in Schema Browser (Data Tab). Very useful if you are an XML developer.
-
This idea is active.Editor »
ANSI to Oracle join syntax converter.
3 comments for Idea: ANSI to Oracle join syntax converter.Add a refactor option in the SQL Editor to the right hand mouse menu with the other refactor choices for the ANSI to Oracle join syntax converter.
-
This idea is active.Utilities »
Add the option 'compare granted privileges' to 'compare schema'
4 comments for Idea: Add the option 'compare granted privileges' to 'compare schema'While doing a 'compare schema',across 2 databases, currently only privileges assigned by a user are listed, not privileges assigned to a user. It would be nice to have a feature that compares privileges assigned to a user, as currently the only alternative is to do this is do perform a full database compare.
-
This idea is active.Editor »
Generate SQL select based on chosen columns
6 comments for Idea: Generate SQL select based on chosen columnsIf this already exists, I do not know how to do it:
I have a table with lots of columns, many of which I am not interested in. I write a select * on that table and then deselect the columns I don't want by using the show/hide columns feature. Once I have the columns I want, there ought to be an r-click option to generate the SQL that chooses only those columns, so I can then use the query over and over again.
Social Web