TOAD Wiki
http://asktoad.com/DWiki/
2008-10-11T03:14:04+01:00TOAD Wiki
http://asktoad.com/DWiki/
http://asktoad.com/DWiki/lib/images/favicon.icotext/html2008-10-11T03:12:08+01:00Matt Wilkins (mwilkins@24.211.169.185)faq:answers:installation
http://asktoad.com/DWiki/doku.php/faq/answers/installation?do=diff1223694728
Toad supports installation on Citrix servers. Toad must be installed on the Citrix server by the Citrix administrator. Users then connect to this instance through their Citrix logon. Citrix support is enabled with the appropriate installation option...text/html2008-10-10T19:37:34+01:00Matt Wilkins (mwilkins@12.173.168.199)faq:questions
http://asktoad.com/DWiki/doku.php/faq/questions?do=diff1223667454
From left to right: Matt, Brad (behind Matt), Mark, Gretchen (behind Matthew), Matthew, Alana, Mike (cue ball), John B (behind Greg), and Greg. Missing are John and Bert who work off site - in the Great Republic of Texas. Getting Started What ...text/html2008-09-08T15:41:29+01:00Matt Wilkins (mwilkins@12.173.168.199)faq:answers:getting_started
http://asktoad.com/DWiki/doku.php/faq/answers/getting_started?do=diff1220888489
Toad is an industry-standard tool for application development. Using Toad, developers can build, test, and debug PL/SQL packages, procedures, triggers, and functions. TOAD users can create and edit database objects such as tables, views, indexes, co...text/html2008-09-08T14:43:13+01:00Norman Dunbar (norman_dunbar@91.195.83.3)faq:answers:datagrid - Added "How do I change the grid popup editor font?"
http://asktoad.com/DWiki/doku.php/faq/answers/datagrid?do=diff1220884993
TOAD 7.5 and up can show TIMESTAMP and INTERVAL data in its data grids if you are using a 9.0.1 or higher Oracle client. TOAD 9.0.1 supports TIMESTAMP and INTERVAL data in its "run as script" function. TOAD versions 7.4 and previous do not...text/html2008-08-19T13:40:12+01:00Norman Dunbar (norman_dunbar@91.195.83.3)faq:answers:tools - Added Databese Compare, sync script topic.
http://asktoad.com/DWiki/doku.php/faq/answers/tools?do=diff1219153212
Yes, starting with TOAD 7.3. However, the Disk I/O graph will be blank. How are "execution time" and "timestamp" computed in the SQL Monitor? Timestamp is assigned to a statement at the moment it is about to be sent to SQL Mo...text/html2008-08-12T14:06:01+01:00Gretchen Mueller (gmueller@12.173.168.199)howto_use_tortoise_svn_with_toad_s_source_control - created
http://asktoad.com/DWiki/doku.php/howto_use_tortoise_svn_with_toad_s_source_control?do=diff1218549961
This file gives details of how to get your scripts, packages and so on under version control using SubVersion: specifically, using TortoiseSVN as the GUI - it integrates into Windows Explorer and is accessed via the right-click context menu. There...text/html2008-08-12T13:53:21+01:00Gretchen Mueller (gmueller@12.173.168.199)howtos
http://asktoad.com/DWiki/doku.php/howtos?do=diff1218549201
HOW-TOs Need to upgrade Toad? HOWTO Get A Toad Upgrade. Getting AVs in the Beta? HOWTO report a beta AV problem Need to know how to do something uniquely TOAD? HOWTO Configure TOAD for Multiple Users on One PC HOWTO Configure an Oracle Dat...text/html2008-05-16T08:38:02+01:00Norman Dunbar (norman_dunbar@91.195.83.3)howto_report_a_beta_av_problem - created
http://asktoad.com/DWiki/doku.php/howto_report_a_beta_av_problem?do=diff1210927082
If you are a member of the Beta testing community and suffer the occasional bout of Access Violation errors then the following is a detailed explanation of how best to report these problems to the developers. The following information is provide by ...text/html2008-03-28T07:54:13+01:00Norman Dunbar (norman_dunbar@91.195.83.3)howto_get_a_toad_upgrade - created
http://asktoad.com/DWiki/doku.php/howto_get_a_toad_upgrade?do=diff1206690853
Courtesy of Jeff Smith : If you want an upgrade/install from Quest for any Quest product, you need 3 things: A license for the product (in this case Toad for Oracle) To be current on your maintenance contract (automatically included for 1 year a...text/html2008-03-27T08:17:45+01:00Norman Dunbar (norman_dunbar@91.195.83.3)faq:answers:database_versions - Added "Under 10g I cannot see the SQL running when I look in V$SESSION".
http://asktoad.com/DWiki/doku.php/faq/answers/database_versions?do=diff1206605865
The short answer is that this is an Oracle 10g DBA best practices issue - and not a Toad problem per se. Toad just happens to expose the symptons since it makes such frequent access to the data dictionary. Oracle versions prior to 10g offered two o...text/html2008-03-11T14:35:51+01:00Norman Dunbar (norman_dunbar@91.195.83.3)faq:answers:schema_browser - Added "finding roles with grants"
http://asktoad.com/DWiki/doku.php/faq/answers/schema_browser?do=diff1205246151
One thing you can do is to right-click over the tabs and choose "Configure". This will let you rename and reorder the tabs. Another option is to choose a different style of schema browser. Go to Options→Schema Browser→Visual and ...text/html2008-03-04T14:50:27+01:00Matt Wilkins (mwilkins@12.173.168.199)howto_install_and_update_freetoad
http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad?do=diff1204642227
After much wailing and gnashing of teeth on the Toad lists at Yahoo with reference to not being able to get the updated FreeToad working, Bert advised the following steps be carried out. Initial, First Time Installation Download the freeware inst...text/html2008-03-02T06:03:03+01:00anonymous@76.235.234.111wiki:talk:faq:answers:sql_editor - Replaced Toad tech question with link to FAQ
http://asktoad.com/DWiki/doku.php/wiki/talk/faq/answers/sql_editor?do=diff1204437783
As the main page says: If you have questions about Toad itself that aren't answered here, see the Getting Started FAQ about contacting Quest directly. ...text/html2008-02-08T09:01:36+01:00Norman Dunbar (norman_dunbar@213.152.224.36)faq:answers:connect - Added new FAQ "Access violation when connecting with a 10g Oracle client".
http://asktoad.com/DWiki/doku.php/faq/answers/connect?do=diff1202461296
TOAD is a 32 bit application and therefore requires 32 bit SQL*Net. Can one connect to Toad for Oracle using ODBC? NO. TOAD requires SQL Net client and does a direct connection - end of story. People often ask this question due to a huge misunde...text/html2008-02-04T15:07:15+01:00Norman Dunbar (norman_dunbar@213.152.224.36)faq:answers:sql_editor - Added URL for the archive thread on the new DLL.
http://asktoad.com/DWiki/doku.php/faq/answers/sql_editor?do=diff1202137635
You could then save your dynamic SQL script to the Script Manager. You would then always have this query available. Alternatively and without the need to spool out sql, try this : begin for x in (select username from dba_users where ...text/html2008-01-31T09:20:19+01:00Norman Dunbar (norman_dunbar@213.152.224.36)howto_remove_instances_from_the_instance_manager - created
http://asktoad.com/DWiki/doku.php/howto_remove_instances_from_the_instance_manager?do=diff1201771219
Once you close and open the IM window, you will only see the instances you selected to be monitored. — Norman Dunbar 2008/01/31 09:14 ...text/html2008-01-02T14:16:17+01:00Norman Dunbar (norman_dunbar@213.152.224.36)faq:answers:performance_issues_and_problems - Added example package code. Tidied formatting.
http://asktoad.com/DWiki/doku.php/faq/answers/performance_issues_and_problems?do=diff1199283377
Recently (December 2007) there was a discussion on the TOAD list about the use of EXECUTE IMMEDIATE and whether there was any advantages to its use over that of the DBMS_SQL package which takes far longer to type and requires more code to get workin...text/html2007-12-07T13:59:03+01:00Gretchen Mueller (gmueller@12.173.168.199)playground:gretchen_s_testing - created
http://asktoad.com/DWiki/doku.php/playground/gretchen_s_testing?do=diff1197035943
This is a test... ...text/html2007-12-07T13:58:01+01:00Gretchen Mueller (gmueller@12.173.168.199)playground:playground
http://asktoad.com/DWiki/doku.php/playground/playground?do=diff1197035881
* Mark's testing ... * Norm's testing ... * Gretchen's testing... ...text/html2007-11-23T18:54:24+01:00anonymous@68.184.42.162wiki:talk:toaddebug.txt - created
http://asktoad.com/DWiki/doku.php/wiki/talk/toaddebug.txt?do=diff1195844064
The file ToadDebug.txt pops up in enexpected places. It's rather annoying, and has no use for me - I don't even know what it's used for. Does anyone know: what creates it (and if there's an option to disable it), and what its used for? ...