Benchmark Factory for Databases – What is Scalability Testing?
Benchmark Factory for Databases – What is Scalability Testing?
In this Benchmark Factory video we explain what is database workload and scalability testing....
Toad for Oracle – How to report a Beta Access Violation (AV)
Toad for Oracle – How to report a Beta Access Violation (AV)
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 bestto report these problems to the deve...
Toad for Oracle – How To Use Toad over an SSH tunnel
Toad for Oracle – How To Use Toad over an SSH tunnel
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...
Toad for Oracle – How To Get a Toad Upgrade
Toad for Oracle – How To Get a Toad Upgrade
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 (automatica...
Toad for Oracle – How do I search for special characters (metacharacters) in the editor?
Toad for Oracle – How do I search for special characters (metacharacters) in the editor?
You can search for various metacharacters in the MOE as follows : CTRL F (or Edit→Find) to open the Find dialogue. Tick the box marked Regular expressions in the Options section. In the Text to...
Toad for Oracle Editor – How to Run Very Large Scripts
Toad for Oracle Editor – How to Run Very Large Scripts
One from Wendy Penfold on the Toad lists: Hi, I need to load a large file of insert statements–44,000. The file is too large to open in the Toad editor, it hangs Toad. Is there a way I can run the sc...
Toad for Oracle Editor – How can I use TOAD to create and run dynamic SQL?
Toad for Oracle Editor – How can I use TOAD to create and run dynamic SQL?
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...
Toad for Oracle Data Grid – Why can’t I edit the results of a query in the SQL Editor?
Toad for Oracle Data Grid – Why can’t I edit the results of a query in the SQL Editor?
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 >...
Toad for Oracle Data Grid – What is the OCI Buffer Array Size option for in the View – Options – Oracle – General section?
Toad for Oracle Data Grid – What is the OCI Buffer Array Size option for in the View – Options – Oracle – General section?
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...
Toad for Oracle Data Grid – How do I name the tabs when I run a script?
Toad for Oracle Data Grid – How do I name the tabs when I run a script?
When you run a script in the MOE using F5, the output of the script is displayed at the bottom of the screen. Each command creates a separate tab for its results, as well as being included in the main...
Toad for Oracle Data Grid – How do I delete a record?
Toad for Oracle Data Grid – How do I delete a record?
Assuming that the result set is editable (i.e. you have written a query that includes the ROWID, or you have used the TOAD Edit command), you can do one of the following: "Delete row" button on the...
Toad for Oracle Data Grid – How do I copy a whole row or multiple rows of data?
Toad for Oracle Data Grid – How do I copy a whole row or multiple rows of data?
To copy one row of data, put your cursor in a cell in the grid and press Ctrl+Insert. This will copy the row and its column headers to the clipboard. To copy multiple rows of data, right-click in the ...