Hi John, No that didnt seem to fix it. Shall I wait for Toad9 or should I try and debug? Every time I try to exit TOAD I get the message - click OK and I am...
What option in TOAD allows a user to see a package body that belongs to somebody else? The user has execute privilege on the package and select on dba_source, ...
Is there a preferred SCC provider for Subversion? For those of you that use Subversion integrated with TOAD, which provider do you use - and why did you choose...
Sure - will do. Got some good queries to *really* flex it's muscles ... LLAP Steve Delia Global Information Management Ethicon Inc., A Johnson & Johnson...
Morning George, ... to ... no doubt one of the developers will jump in and tell me that I'm wrong (again) but, I went in to the scheme browser and selected a...
send me your toad.elf and I'll dig deeper. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of neal clark Sent: Friday, March 31, 2006...
I was thinking perhaps the setting View->Options->StartUp->"Check for access to DBA views" isn't checked? Rich -- [TeamT] ... From: toad@yahoogroups.com...
Hey Dean, Check out the value of: SELECT VALUE FROM v$nls_parameters WHERE parameter = 'NLS_NCHAR_CHARACTERSET'; I'm guessing that you're going to find the...
Duh ! I forgot about UTF8. I'm running AL16UTF16 as my NCHAR set. MAybe that's why I can see them and Dean cannot. Cheers, Norm. [TeamT] Norman Dunbar. ...
Several Toad users have asked me, "Does Toad have a Null Hunter" feature?" or "What is the best way to find out how many NULLS exist in a table with a few...
Patrick McGrath
Patrick.mcgrath@...
Apr 3, 2006 5:34 pm
32194
Hi, I have just installed TOAD 7.6.0.11 and when I try to run a Stored Procedure, I see the buttons run, step over, set parameters, etc...desable. Do I have to...
In the current GA -- Create table x with columns a, b, and c Insert some data View the data via either SB or F4/data tab Create a filter on column b Now drop...
do the users want to blindly seach all columns in all tables? or just a single table? I can't think of a way to do that off the top of my head. an easy way...
I just tried this in 8.6, and got the message about the filter being invalid. After that the filter was automatically removed and then when I clicked refresh,...
Alfredo, When you do Help -- About, do you see Debugger in the Options? If yes, only then you will be able to debug the stored procedures etc. Hope this helps....
Hello, I've got another enhancement request, based on current behavior of 8.6.0.38. When I execute a script in SQL Editor, and that script has a CONNECT ...
The usual "Null Hunter" request is focused on a single table to determine the number or percentage of nulls in a single selected column. The request then...
Patrick McGrath
Patrick.mcgrath@...
Apr 3, 2006 7:57 pm
32201
The first thing I'd recommend checking: server side objects You need the server side objects both available and useable. An example is the dbms_debug package....
rsimonea@...
Apr 3, 2006 7:57 pm
32202
One Caveat: "best way" being defined as most optimized (runs quickest) My understanding of Oracle: null values are not indexed If that's true through 10g, then...
rsimonea@...
Apr 3, 2006 7:58 pm
32203
<top of my head> Perhaps properly collected statistics and DBA_TAB_HISTOGRAMS would get you your result? </top of my head> I was thinking the National...
Alan, I'm in the process of reworking the script processing for 9.0 and this was already in the works. In addition, all of the script dialogs/grids/outputs...
good thinking Rich. a query like this could be used to get some insight into the answer to such questions: (and soemthing like this could be added as a custom...
Morning Patrick, just sticking my oar in here - because I must be missing something, but ... my ... contain a ... with ... surely, if a column's definition...
My apologies to the gang. I neglected to add toad to my out of office exceptions. :-( Quest is a sponsor here at the Sungard Summit. :-) Sorry to mess up your...
That's great! One other thing I forgot to mention, in case you haven't already considered it, is to suppress the prompt if the requested connection is already...
In addition to the below if you are on 10g then you need to have the "DEBUG CONNECT SESSION" system privilege. http://toadsoft.com/faq2.html#ProcedureEditor6 ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
