http://asktoad.com/DWiki/ 2012-01-11T12:42:11+01:00 http://asktoad.com/DWiki/ http://asktoad.com/DWiki/lib/images/favicon.ico text/html 2011-11-01T16:03:46+01:00 Rich Jesse (richj@99.19.251.22) http://asktoad.com/DWiki/doku.php/wiki/playground?do=diff1320163426 If you post junk here, it will be removed, you silly spammers. ... text/html 2011-09-22T16:30:25+01:00 Rich Jesse (richj@12.106.238.251) http://asktoad.com/DWiki/doku.php/faq/answers/getting_started?do=diff1316709025 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/html 2010-09-13T18:39:43+01:00 Rich Jesse (richj@12.106.238.251) http://asktoad.com/DWiki/doku.php/howto_create_dblinks_database_links_in_another_schema?do=diff1284403183 So, you've decided to create DBLINKs in a few application schemas. As with every other CREATE statement in Oracle 9i+, you'll do this from a DBA account to save some hassle. But when you try to create your first link from your DBA account: CREATE D... text/html 2010-08-10T14:58:29+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/troubleshooting?do=diff1281452309 SQL Monitor is a great little tool that's bundled with Toad starting at or near version 8.0. It is an extremely useful tool to see what statements Toad is generating behind the sceens. To launch SQL Monitor from Toad find the External Tools icon me... text/html 2010-08-03T14:48:33+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/howto_see_which_table_a_lob_segment_belongs_to?do=diff1280846913 A question asked on the Toad Lists was something like this I remember, I think, that Toad allowed me to see the table or index that a LOB Segment belonged to from within the Database→Administer→Tablespaces Objects tab. For the life of me, ... text/html 2010-08-03T14:47:34+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/howtos?do=diff1280846854 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/html 2010-06-30T15:49:08+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/howto_use_toad_over_an_ssh_tunnel?do=diff1277912948 Ever had the worry that when you connect to a database to send some data to it, that some eavesdropper on the network might just be waiting to catch all your passwords (Oracle sends passwords in plain text - by default - go figure) and sensitive dat... text/html 2010-04-14T18:24:12+01:00 Gregory Liss (gliss@64.105.180.10) http://asktoad.com/DWiki/doku.php/faq/questions?do=diff1271269452 (click pic to enlarge) Back Row (L to R): Matt, Greg, Brad, John B. Front Row: Mike, John D, Melanie, Lenka, Mark Picture taken April 2010 Getting Started What is Toad for Oracle? What are Toad's system requirements? Licensing and Add-on M... text/html 2010-03-16T08:10:53+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/faq/answers/installation?do=diff1268727053 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/html 2009-07-22T18:08:36+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers/sql_editor?do=diff1248286116 This page of FAQ answers has been merged into the Editor page. — Rich 2009/07/22 18:04 ... text/html 2009-07-22T18:07:27+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers/procedure_editor?do=diff1248286047 This page of FAQ answers has been merged into the Editor page. — Rich 2009/07/22 18:04 ... text/html 2009-07-22T18:06:34+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers/editing?do=diff1248285994 This page of FAQ answers has been merged into the Editor page. — Rich 2009/07/22 18:04 ... text/html 2009-07-22T17:51:00+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers/editor?do=diff1248285060 For a more comprehensive review of all the new Editor features, click here "Format Code" isn't working. It corrupts my code, or it doesn't use any of my Formatting Options. What's going on? If Formatter Plus is licensed on the machine,... text/html 2009-07-22T17:46:37+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers?do=diff1248284797 command_line connect customization dbms_output datagrid documentation_help editing editor explain_plan fastreports gui general ini_file installation procedure_editor project_manager queries sql_editor schema_browser tools windows... text/html 2009-05-01T09:43:27+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) http://asktoad.com/DWiki/doku.php/faq/answers/unicode_support_in_toad_10?do=diff1241171007 An email to the Beta group went as follows: From: toadbeta@yahoogroups.com [mailto:toadbeta@yahoogroups.com] On Behalf Of Brad Boddicker Sent: Thursday, April 30, 2009 10:22 AM To: toadbeta@yahoogroups.com Subject: [toadbeta] Beta 9.8.0.29 released... text/html 2009-02-03T21:41:04+01:00 Bert Scalzo (bscalzo@71.170.70.37) http://asktoad.com/DWiki/doku.php/faq/answers/database_versions?do=diff1233697264 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/html 2008-12-01T19:41:42+01:00 Rich Jesse (richj@12.17.117.251) http://asktoad.com/DWiki/doku.php/faq/answers/fastreports?do=diff1228160502 Yes, in the preview window, the 4th button on the top toolbar says "Export" when you hover your mouse over it. Click it. Several formats are available. How can I add my own style to the report wizard? Save this into a file called &quot... text/html 2008-10-21T14:47:54+01:00 mwilkins@12.173.168.199 http://asktoad.com/DWiki/doku.php/faq/answers/general?do=diff1224600474 When Toad first loads, the main MDI screen appears and an initial Toad Server Login Window is displayed. This window will prompt for a Database, UserName, and Password. The database name should be one of the valid Oracle TNS entries. The user and pa... text/html 2008-09-08T14:43:13+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) 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/html 2008-08-19T13:40:12+01:00 Norman Dunbar (norman_dunbar@91.195.83.3) 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...