http://www.asktoad.com/DWiki/ 2010-08-10T16:02:10+01:00 http://www.asktoad.com/DWiki/ http://www.asktoad.com/DWiki/lib/images/favicon.ico text/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/command_line?rev=1142920952 No. Quest Central does not support the TOAD command line options. How do I use the command line options to make TOAD do something every night? For any of the windows that support command line execution: Go to the window and set your options as... text/html 2008-02-08T09:01:36+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/connect?rev=1202461296 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/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/customization?rev=1142920952 You can either make TOAD read-only, by copying readonly.lic over toad.lic, or revoking Oracle system privileges, e.g., "create table" from those user accounts. You can also download a read only TOAD from Quest's website, or use TOAD Securi... text/html 2009-02-03T21:41:04+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/database_versions?rev=1233697264 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-09-08T15:10:37+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/datagrid?rev=1220886637 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 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/dbms_output?rev=1142920952 No. The DBMS buffer is not released by Oracle until the PL/SQL block completes. If you are not seeing the DBMS Output after the block executes, make sure that before you run the block, you toggle DBMS Output on via the DBMS Output tab in the SQL Edi... text/html 2007-07-26T13:44:27+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/documentation_help?rev=1185457467 Go to http://www.toadsoft.com/downld.html and look near the bottom of the page for a link to the latest help. The help should also be installed with the GA. If you are using the network installation, then the help is installed to the server. Why c... text/html 2009-07-22T18:06:34+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/editing?rev=1248285994 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 http://www.asktoad.com/DWiki/doku.php/faq/answers/editor?rev=1248285060 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 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/explain_plan?rev=1142920952 This was a bug in TOAD 7.4.0.1. A patch was released (version 7.4.0.3). At the current time, TOAD 7.6 can be downloaded from Quest's website. Why do I get an "ORA-00904 Invalid column name" when I run an explain plan? Check that the que... text/html 2008-12-01T19:44:00+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/fastreports?rev=1228160640 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 http://www.asktoad.com/DWiki/doku.php/faq/answers/general?rev=1224600474 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 2009-07-27T18:35:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/getting_started?rev=1248719732 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 2006-05-22T15:45:19+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/gui?rev=1148312719 For upgrading users that have a connection history grid from previous Toad versions, connection colors will have to be selected from the previous connections grid in order to take affect. A connection color can be chosen for an existing connection u... text/html 2006-06-06T12:54:30+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/ini_file?rev=1149598470 This will cause TOAD to use the old (Oracle 7) Sqlnet calls in the OCI dll rather than the newer Net8 calls. If this is set to FALSE (0), you will be unable to view BLOB, CLOB, NCLOB, user-defined object type, timestamp, and interval data, and you m... text/html 2010-03-16T08:10:53+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/installation?rev=1268727053 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 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/networking_issues?rev=1142920952 TOAD requires a complete 32-bit SQL*Net or Net8 installation. It is not sufficient to run SQL*Plus and conclude that SQL*Net/Net8 is installed properly because SQL*Plus does NOT use all of the same infrastructure and components that TOAD uses to con... text/html 2008-01-02T14:31:35+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/performance_issues_and_problems?rev=1199284295 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/html 2009-07-22T18:07:57+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/procedure_editor?rev=1248286077 This page of FAQ answers has been merged into the Editor page. — Rich 2009/07/22 18:04 ... text/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/project_manager?rev=1142920952 This example shows how to load a script into SQL*Plus for the current session and execute it: Go into PM Options → Associations Remove SQL as an extension for SQL Editor (or anywhere else it may be) Click Add Title: SQL Plus Program: C:\or... text/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/queries?rev=1142920952 The _ is a wildcard for any single character. You must specify the escaping within the SQL statement itself. Here's an example: ...WHERE usr_login LIKE '%\_del%' ESCAPE '\'; How can I cancel long running queries? If you are running version 8.5 o... text/html 2008-03-11T14:35:51+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/schema_browser?rev=1205246151 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/html 2009-07-22T18:08:36+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/sql_editor?rev=1248286116 This page of FAQ answers has been merged into the Editor page. — Rich 2009/07/22 18:04 ... text/html 2008-08-19T13:40:12+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/tools?rev=1219153212 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/html 2009-05-01T09:43:27+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/unicode_support_in_toad_10?rev=1241171007 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 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq/answers/windows_registry?rev=1142920952 Not regularly. However, the installation routine writes to the registry, and the trial only routine also writes keys to the registry as described below. The installation routine writes several items to the registry, including the Client directory an...