Topics - - Toad for Oracle - Toad World

Do you have an idea to improve Toad for Oracle? We want to hear it! Idea Pond is 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 click the green "Submit New Idea" button to submit your idea.

Idea Pond is just for submitting enhancement suggestions. If you need help or found a bug, please contact Dell's Product Support. You can also join our forums for assistance. See our FAQ for more information about Idea Pond.

All Ideas

Kevin Krause
Follow / 4 Feb 2016 at 8:29pm / General

Allow the selection of multiple tables from the explorer to compare

Many times I'd like to compare several tables (but not all tables in a schema). There are too many tables in the schema to compare the entire schema (overkill). As an example as part of project I may have changes to 10 tables.... I would like run...
0 / Active
Damir Vadas
Follow / 29 Jan 2016 at 6:48pm / Grid

Grid sected number of records and custom popup menu

1) In many cases (like in partitions grid) I select some records and cannot se the number of selected rows.... 2) I would like to be able to have custom popup menu in grids. For instance I would add for selected records to generate gather stat, select...
0 / Active
Follow / 29 Jan 2016 at 1:14pm / General

Option to select the order of the colums in a table script

Oracle 12 introduces the feature of hidden colums. If you make some table columns from the "middle" invisible and visible again, look into the column tab for that table - they have moved to the end now, because Oracle reorders the COLUMN_IDs...
6 / Complete
Gregory Liss
Follow / 27 Jan 2016 at 8:54pm / Utilities

Ani idea about having an idea

If I have an idea about having an idea, where would I submit it?
2 / Active
Susan K
Follow / 20 Jan 2016 at 6:48pm / Schema Browser

Additional Materialized View status icon required for MVs that are in a 'Need...

It appears that maybe we need another icon for the materialized views in the schema browser. After chatting with Oracle support, a materialized view is not bad when its compile state is 'Needs Compile'. It should only be marked with the X, when...
0 / Complete
Follow / 19 Jan 2016 at 1:47pm / Schema Browser

Tabs for Views are missing constraints

Hi, Views (similar to tables) can contain constraints. Currently the only way to see constraints on a view is to go to Scripts. It would be nice to be able to see them as a tab similar to the tables overview Thanks, Mau.
0 / Complete
Follow / 19 Jan 2016 at 8:35am / Import/Export

Export to SqlLdr-script should have an option to re-enable constraints

Hi, I really want to use the "export data to sql loader" functionality. However, it does not insert a line with the command "reenable constraints" in the SqlLoader-file itself. This should be an option since it caused a huge bug...
1 / Complete
Hans-Werner Schlote
Follow / 15 Jan 2016 at 9:31am / Editor

BEGIN should have anchor in Navigator panel

Consider PL/SQL block with several local modules, e.g. procedure proc1 within package pkg1, proc1 has several local modules (functions, procedures). In navigator panel you get pkg1 - Local Subprograms -- p() proc1 --- Parameters --- Declarations...
2 / Active
Hans-Werner Schlote
Follow / 15 Jan 2016 at 8:24am / Editor

Ctl LeftClick should work for local modules

Ctl-LeftClick on t_lm.call_local jumps to definition of t_lm.call_local => okCtl-LeftClick on l_fun does not jump to definition of l_fun => error in my humble opinion see Service Request 2901084, CR118295 CREATE OR REPLACE PACKAGE t_lm AS FUNCTION...
0 / Active
Follow / 12 Jan 2016 at 10:24am / Utilities

Option for Restricting IDENTITY option from being compared in TOAD Schema compar...

In Toad schema comparison, If there is a option (Check box) for restricting the System generated objects from being compared, it will be advantageous when performing schema integration. There is a option for selecting / un-selecting the max, min values...
1 / Complete
Follow / 23 Dec 2015 at 7:44pm / General

Add Team Coding support for Scheduler Jobs

Please add Team Coding support for placing Scheduler Jobs under source control.
0 / Active
Follow / 22 Dec 2015 at 11:29am / Editor

change back to filter statements in SQL Recall by sqltext in Header auf SQL Reca...

The new feature "SQL Recall Apply Filter" is very cumbersome to use. I wish to have a filter the sqltext in the top of sql Recall!
0 / Active
Follow / 17 Dec 2015 at 7:16am / Grid

Change back to show result as when using Load into Grid also for Fetch into Cursor...

We use Execute Procedure with Load into grid as output option extensevly. With Toad 12,8 this has been replaced with Fetch to cursor, but the result is not as expected. Previously the result was shown at once in a grid, but no I have to doubleclick...
0 / Active
Follow / 8 Dec 2015 at 11:42pm / Editor

Formatting with Pivot statement

It would sure be nice to be able to format code containing the pivot clause. Example: PIVOT (LISTAGG ( pgm_status, ' -' ) WITHIN GROUP ( ORDER BY pgm_cd) for pgm_cd in ('1073' as ccp_status , '1071' as aptc_status , '1072'...
0 / Active
Hans-Werner Schlote
Follow / 7 Dec 2015 at 1:32pm / Other

team coding manager > check-in all: show vcs status, right-click context menu...

team coding manager > check-in all: add column "vcs status" for status values see Right-click context...
0 / Active
Hans-Werner Schlote
Follow / 7 Dec 2015 at 12:00pm / Other

VCS/SVN icon overlays in project manager, team coding manager and tab title

It would be great to see the SVN status of a file in project manager and team coding manager, like icon overlays for windows explorer with TortoiseSVN. Thus one could see whether a file is under vcs control, locally modified, locked, ... Like * for...
0 / Active
Hans-Werner Schlote
Follow / 7 Dec 2015 at 11:37am / Other

SVN integration - support working directory names that differ from repository pr...

At the moment TOAD persists on repository project being the same as the SVN working directory. E.g. in TOAD terms: Repository URL: https://.../prj1/trunk Repository Name: trunk Working Directory: c:\svn\prj1 Actually with regard to SVN https...
0 / Active
Hans-Werner Schlote
Follow / 2 Dec 2015 at 7:47am / Other

Project Manager - toggle between project manager and editor

When opening a file from project manager the scope remains on project manager. To edit the file one has to click into it. At least I couldn't find a way to activate the editor window using the keyboard. It would be great to have a shortcut to switch...
0 / Active
Follow / 17 Nov 2015 at 7:32am / Connections

Save passwords for only non production databases

Could you make it possible to only save password for non production database? For development, test or acceptance databases I would like to be able to save my passwords. On those databases my database account doesn't have a profile which requires...
2 / Active
Follow / 4 Nov 2015 at 11:21pm / General

Customized DDL code generation for Toad for Oracle

Customized DDL code generation for Toad for Oracle Description I see that the Toad Data modeler has the ability to create custom DDL. Is this or will this ever be available using Toad for Oracle. It would be very useful to the developers when...
1 / Active