set echo off set heading off set feedback off SPOOL c:\temp\all_tmp.sql select 'alter user ' || username || ' temporary tablespace TEMP;' from dba_users where temporary_tablespace != 'TEMP'; SPOOL off...
Check to see whether you have an object named the same as the owner of the procedure. When this is the case, Oracle thinks that the user name in the anonymous block is actually the object name. We rec...
Q: When I describe a table (say hit F4 on the table name in a SQL query) I often like to copy and paste Column Names from the Columns tab into a SQL statement – however when i do paste it, the column ...
What I'm trying to pin down is how accurate the execution time displayed in TOAD is. For some complex queries, the time displayed may be 1 second. If I trace the query using TKPROF it reports about 4 ...
In Toad for Oracle 11.6, go to Options | Editor | Execute/Compile in the solution below. For earlier versions: Sometimes you have to use version control to ensure that you have a full history of what...
Q: What is FastReports? A: FastReports is the report engine in Toad that allows for custom and dynamic reporting against live data sets. FastReports is included with the standard edition of Toad for ...
To resolve these problems, go to Edit → Editor Options and look under "General Options", under the "General Options" node, where there are several options related to tab stops. Unchecking "Auto indent...
Q: How to import data from an Excel file into a table? A: See Toadworld blog post "Create and Load Oracle Tables from Excel Spreadsheet using Toad“ Q: I have a flat file (.csv, tab delimited, etc.)...
Toad for Oracle online Help is installed with the product. If you are using the network installation, then the help is installed to the server. You can also always find a copy of all documentation he...
On the Toad list, a poster asked what is the best way to save or import my previous settings into a new version of Toad. Further information confirmed that the user was about to get a new PC and was ...
Query statements MUST return the ROWID to be updatable. For example: select * from employee where salary > 2000 would not be updatable, whereas: select employee.*, rowid from employee where salary >...
After a SELECT query is executed, we must retrieve the rows from the Oracle server to your PC. We do not retrieve the rows all at once, nor do we retrieve them one at a time (unless there is a LONG or...
