You will no longer receive e-mail notifications from this forum.
Log-In to post
The new Compare Schemas Wizard provides an easier to use interface for doing a one-to-one comparison between schemas. One of the unique features of the Wizard is to allow for the adding or checking in of the generated script to source control. The new Window can be found under Toad's Database > Compare menu item or from within Toad's Automation Designer.
Team Coding/Source Control
The ability to view annotations for VCS files has been added to Team Coding's Object Properties window. Annotations allow you to view the line-by-line contents of a file, as well as the revision and author when that line was last modified / added. Hovering over the revision number in this tab will show details for the revision in a hint.
If I've added a whole section of code, most compare utilities I've used will jump to the next group of differences, rather than stepping through each line in the section of added code..
At least it should be an option, if someone really finds the current behavior useful.
Adding unit tests to VCS is now supported in Team Coding. This applies to unit tests created within TOAD from the PL/SQL results window. To enable this feature:1. Open the TC Configuration window2. Add the schema for the user which will create unit tests to a new or existing team project and select the "Unit Test" object type.Note: Unit tests are tied to the user who creates the test, not to the database object on which the test is run.
Added a "Format source before comparing" option to the "Compare Files" window. Checking this option will automatically format both files before performing the comparison.
- Formatter: The alignment within the first statement ("chunk") of SQL text was offset by one position at times, as shown in the following example: GRANT ALTER, CONTROL, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE ON "ADVISE_INSTANCE" TO ROLE "RL1";In a few other cases tokens were not correctly positioned.- Formatter: CREATE/ALTER TABLE/SEQUENCE: Moving some left hand side commas at the right hand side.- Code Analysis: Possible access violation in component QP5CA.dll on invalid Oracle $IF/$ELSE/$ENDIF syntax.- Code Analysis: After the work on rule 6406 ("Avoid multiple definitions of the same element in nested scopes.") the Rule Universe was wrongly left unchanged causing the old legacy logic still to be used.- Code Analysis: Rule 5809 ("Ensure elements in the SELECT list (either columns or expressions) are qualified by a table/view name.") now only hits when more than one table reference, unless we have queries in the WHERE clause.- Code Analysis: Rule 3807 ("Avoid using a RETURN statement in a procedure.") has been removed as it duplicates Rule 5601 ("Avoid using RETURN statements in a PROCEDURE.").
Editor - Debugger
Execute PL/SQL - Set ParametersInput argument values can be set to SELECT statements. Set the argument's type to expression and its value to a SELECT that returns a single column and single row.
I just installed beta 126.96.36.199 and tried the file compare utility.
Looks great! Especially the option to ignore formatting differences is a great improvement over any other comparison tool.Unfortunately, it does not seem to work as it should:
Also, I could not figure out how to compare a directory.I got a message stating that I can load only two files at a time.
I tried to find out by hovering the cursor over the action icons, but there seems to be no pop-up, help-text, or explanation available.
I hope this helps you guys to improve the compare feature.Intelligent compares will save me a significant amount of ime!
Kind regards,Abe Kornelis==========
I'm currently on Toad 188.8.131.52
Messages in the script output window appear to be damaged:
For example, the space between create and index has disappeared,?as it has between alter and table.
A bigger problem are the lines with just a number and a period.Are they lines inserted? Deleted? Updated? There's no way to tell.
Could you please fix this?
Thanks in advance,Abe Kornelis==========
I was trying to check-in a change to a stored procedure and the TFO status window shows this ....
09:50:33 Output: Error checking in all files: Error uploading file: Scheme.StoredProcedureName.PRC
Where can I find the actual error?
New window under Main Menu -> Session -> Transactions. Lists each connection and if it has a pending transaction or not. You can set it to auto-refresh if you want. You can commit or rollback from that window too, and it is stay-on-top but not modal, so you can leave it open if you want while you work elsewhere in Toad.
Oracle 12c R2 Support
- DML, expressions, functions, common clauses and DROP statements.
- CREATE FUNCTION/LIBRARY/PACKAGE/PROCEDURE/TRIGGER/TYPE statements
Code Analysis Rule 4603
Rule 4603 ("Avoid literal concatenations at runtime.") would fire unexpectedly due to a (minor) Rule Universe issue.
Support for functions in a PIVOT clause having a WITHIN GROUP clause (undocumented feature).
Formatting many more instances of the following statements, mainly 12c R2. Currently about all Oracle DML and DDL statements are formatted.
Code Analysis Rule 5809
Rule 5809 ("Ensure elements in the SELECT list (either columns or expressions) are qualified by a table/view name.") Enhancements.
Rule 4603 ("Avoid literal concatenations at runtime.") The rule will now flag all concatenations in a multi-concatenation.
An option navigator has been added to SB-Types-Spec/Body tabs. In addition, you can now use CTRL+Shift+PgUp/PgDown to jump between the current subobject in Spec/Body tabs.
Compare Files action
New in automation designer: Compare Files. It's on the "File Management" tab.
You can compare a pair of files or all files in a pair of folders.
Output can either be a text file listing missing/matched/differing files, and/or a true/false result from the action (true/false could be used with an if...then action)
I like the way that Spec and Body are displayed in different tabs (think that this is better than the solution with packages), but this does not allow to use Ctrl+Shift+Up/Down to navigate between Spec and Body. It works in the Editor though.
Is there an easy way to enable this in the Describe Window too? Thanks!
Disclaimer: I don't usually code packages with that much functions ;-)
Use the following code to generate a package source:
SELECT 'CREATE OR REPLACE PACKAGE toad_test AS' FROM dual UNION ALLSELECT ' FUNCTION f' || ROWNUM || ' RETURN NUMBER; -- comment' FROM dual CONNECT BY ROWNUM <= 5000 UNION ALLSELECT 'END;' FROM dualExecuting the generated package with F9 seems to take approx. 10 seconds before actually compiling and another 5 seconds after compiling - the real compilation takes 2 seconds.Reducing the package to "only" 1000 functions seems to reduce the total time to 1 second.
Should not be too relevant for packages with a sane size, but I thought I'd let you know in case there was a quick win that might also affect smaller packages.
Is there any reason Editor will not produce an explain plan for a CREATE TABLE AS statement? Session Browser will show the plan, but Editor does nothing when I try to display a plan.
I am working with both windows and linux files, so I have different line-endings.
TOAD offers the option to choose the line-endings, but is there an option to let TOAD detect the line-endings when opening a file?The current option is useful for new files, but when opening an existing file I think it would be better to preserve the existing style.
Explain Plan -> Show Object Usage: Explain Plan tree now selects corresponding node when you click around in the object usage dialog.
I cannot Ctrl+Click on in_some_object, because both the object and the member are highlighted.
CREATE PROCEDURE test_me( in_some_object IN some_object)ASBEGIN dbms_output.put_line( in_some_object.some_member );END;