Dear all, Is there any tool for logging with toad?. Please send if there is any logging tool othere than LOG4PLSQL Thanks in advance Mahesh Ravindran...
Mahesh Ravindran
maheshravindran@...
Apr 1, 2004 1:26 pm
22015
Hi, I´m a new member in this list. I have the following problem: I would like to discover which column is acessed by what procedure. I already have the source...
I have a DBA who is trying to compare 2 schemas (using 7.4.0.3) that have LOBS. In the output under "Objects in both schemas but with differences" the tables...
The lobs may be in different tablespaces or have different storage parameters. try extracting the DDL for each one and doing a file compare on them - that...
Hi, If I generate insert statements (save as) from the data grid in the schema browser and that data contains "&", when I try to run all the inserts as a...
how do I set the sorting order in schema browser so that eveytime I click on it it doesn't ask me how do I get to schema browser by default on my login I am...
Background: a developer came up against what I assume is a limit in Toad, but I thought I would ask if anyone else has come across it. She is trying to pass...
Hey folks, it's been a few weeks, but we've posted a new QSR beta. New for this week * B25 - AV for 7.3 client has been addressed. * REFCURSOR variable has...
Do you mean integration with named SQL's, or a separate facility? ... From: Erwin Rollauer [mailto:erwin.rollauer@...] Sent: Friday, December 12, 2003...
We make extensive use of packages for our PL/SQL code. By default, only the owner can see the body text of the procedures. Our application developers would...
This one's in the TOAD FAQ Why can't I see package bodies from another schema on the Procs tab? Package bodies that belong to another schema appear in the...
To expand on that: this is an Oracle behaviour issue, rather than a TOAD-specific one. You can see your own package bodies because for that you only need...
Hi every one, Does any one integrate Toad with Rational ClearCase source control? I will really appreciate if you can shed some light on that. Thanks in...
Hames: I had successfully done so once. Here is what I did. My version is 7.6.0.11 Go to view -- options -- team coding in the bottom frame named legacy source...
Options > Data Grids - Visual > Confirm sorts when clicking on column header Options > Windows > check "auto open" for schema browser Note that TOAD 7.6.0.11...
TOAD uses views that Oracle provides, but unfortunately those views don't tell us which columns are referenced. You can do a "Spool SQL" (under the Tools menu)...
Philippe Van Eeckhoudt will be out of the office starting 02/04/2004 and will not return until 19/04/2004. As you can see, I'm out for the moment. For any...
pvaneeckhoudt.cs@...
Apr 2, 2004 7:11 pm
22034
Abhijeet, Thank you so much! I have clearCase installed, but, my problem is, it is not showing up in the combo box! I guess I have to talk to our System Admin...
There is usually another Source Control component that needs installed that enables the SCC compliant programs to be integrated with TOAD... ... From:...
James, I have clearcase installed on my machine and the vob is also on my machine, and did not do anything to get clearcase to appear in the combo. I am sure ...
I'm not sure, but to get it to show up in the combo box, you may need to check an additional item in the installation process for the Clearcase client in order...
1) Is there a shortcut keystroke that will bring up the "Select Session" dialog box (not the "new connection")? 2) When I DESCRIBE a view, and click on the...
Hi, At the SQL prompt issue this command before running the script. Set define off; Best Regards Ra'ed Al-Fararjeh Technical Consultant Houston Technologies...
(1) I like Erwin's idea. Add a Named SQL Node, which when launched would (say) * Open/Activate SQL Editor * Select Named SQL * Replace/Append SQL (2) While...
Is there a way to view the current SQL statement in Session Browser? I think this is eventually going to replace Kill/Trace Session, but don't see the current...