How To Write a Cross-Database Query
Introduction When writing a normal SQL query, the user is typically working in a SQL authoring program that is connected directly to the RDBMS in which the query will be run. 1 – Simple Client Conn...
Introduction When writing a normal SQL query, the user is typically working in a SQL authoring program that is connected directly to the RDBMS in which the query will be run. 1 – Simple Client Conn...
There may be times were it is desired to remove all the transactions latency (ie setting to No Delay) for all sessions imported in. And, due to the size of the import, there may be a large number of t...
When using the debugger in TOAD you are able to set various options, paramters etc in a small anonymous block of PL/SQL. While this is fine for non-web oriented PL/SQL code, it doesn’t work with Web b...
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...
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...
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...
Let’s face it – it’s a rough and scary computer world we live in today. We have people routinely losing notebook computers with massive local copies of confidential records, computer hackers aggressiv...
On the database server, go to $ORACLE_HOME/rdbms/admin copy utlxplan.sql to utlxplan.sql.original – you don’t want to lose the original Oracle script. Edit utlxplan.sql and change it to the following...
Q: Escaping the '_' Character: How do I escape out the '_' character in a query? A: The _ is a wildcard for any single character. You must specify the escaping within the SQLstatement itself. Here's ...
The tablespace map uses a simplified fragmentation formula. The key points in question: What is the 'sum of the blocks for that segment'? SELECT sum(blocks) FROM dba_extents WHERE tablespace_nam...
An undocumented (well, up until the help file for Toad 10.6 anyway ) way to trace the amount of time various startup routines take is to edit your TOAD.INI file and add some or more of the following l...
Determine your ORACLE_HOME value. The first thing to check is the ORACLE_HOME value. Examine the following key in your Windows registry: HKEY_LOCAL_MACHINE\Software\ORACLE There should be an entry fo...