I have installed the version 8 under c:\TOAD8 rather than c:\Program Files\Quest Software\TOAD. Script manager still thinks standard scripts are located under...
Tolkun, You don't have to edit the data file, you can use Script Manager to change all the directories at once by using the "Move" button. Mark _____ From:...
My Oracle version is 11.5.9 and my TOAD is 7.6.0.11 Thanks, Kwandile ... From: Peter van Rijn [mailto:petervanrijn@...] Sent: 30 November 2004 05:32 PM ...
Simply put, you must set up the environment from which you run the UPDATE to match the environment that would be generated by the application. Since the...
Hello, I recently wrote a very complex Oracle 9i SQL query that used the GROUPING SETS clause to return data based on seven different groupings. The query ...
Kenneth.Fitzpatrick@...
Dec 1, 2004 4:22 pm
25063
... It's quite simple - TOAD is a quite superlative product designed and developed by the most superb set of programmers this side of Alpha Centauri. Steve...
Sorry, your question never got up the ladder to me. One reason Toad behaves differently is because its not using ADO. ADO is Microsoft. That pretty much says...
Did you try it with SQL*Plus. It could be a problem with what Oracle client or oracle home you are using. You may have two one for Oracle 8 and one for 9. It...
Thanks for the information Jeff, I will look into ODAC. I am still curious why it did not work from the package procedure. Although I was using ADO to call the...
Kenneth.Fitzpatrick@...
Dec 1, 2004 7:08 pm
25067
I will try SQLPlus, I didn't think of that. Thanks ... From: Erwin Rollauer, Mr [mailto:erwin.rollauer@...] Sent: Wednesday, December 01, 2004 11:52 AM ...
Kenneth.Fitzpatrick@...
Dec 1, 2004 7:10 pm
25068
I agree!! I love Toad. ... From: Steve Jelfs [mailto:steve@...] Sent: Wednesday, December 01, 2004 11:40 AM To: toad@yahoogroups.com Subject: Re:...
Kenneth.Fitzpatrick@...
Dec 1, 2004 7:21 pm
25069
Hopefully an ADO expert on the list can answer this better than I... ... From: Kenneth.Fitzpatrick@... ...
My DBA group is constantly trying to get me disconnected from the database when I have the schema broswer open. They maintain that having the schema browser...
TOAD doesn't do any query over and over to keep your session alive. Are you looking at tables in data tab? The only thing that I can think of is if the tables...
Power to the People! Here's something you can do 1)Run the SQLMonitor application - you'll see that toad does a dual connection to check for connection status....
yes, Sergey's SQL monitor is always a good utility to pull up when there is a performance problem. I don't think dbms_output has anything to do with it though,...
True, but the dual and dbms polling are the only 2 queries I knew of that Toad does routinely... ... From: John Dorlon [mailto:john.dorlon@...] Sent:...
Hi, I'd like to fully integrate our version system (PVCS) with automatic formating the source code. Ist there any way known to use the Quest Formatter Plus in...
I'm sorry, but the formatter is not designed to be run from the command line. At the moment the only way to batch format is to manually add a folder of SQL...
Daniel Norwood
daniel.norwood@...
Dec 2, 2004 2:13 pm
25078
John's solution resolved my issue. Thanks for all of your help on this. Mark...
Hello, I don't have the Import function enabled in this version. can anyone tell me how to enable so I can do Imports into my Schema? Thanks, Steve Gara ...
For now you'll need to purchase the commerical copy to get this. ... From: Steven Gara [mailto:stevengara1@...] Sent: Thursday, December 02, 2004 12:46...
We have made available today a patch for the 7.5 release that offers full support for Unicode - Toad for Oracle, version 7.5.3. Go here to learn more - ...
... 7.5.3. ... <snip> Very interesting, but the web page basically repeats itself. It's almost like someone copied and pasted the html once too often :)...
Lol. Too bad I don't get paid by the word. Its fixed... Hey, at least I copied and pasted my own code. Didn't John Fogerty get sued for plagiarizing himself?...
Converting Toad to fully supported Unicode was not a trivial task. Our primary goal was to provide a product to our customers that delivered Unicode suppport....
Lisa Waugh
Lisa.Waugh@...
Dec 2, 2004 10:32 pm
25086
I had a hunch it was something like that. I don't think many Unicode users will be complaining :)...
When creating a script file for a table definition. When I choose to save it to a file. If I type in a file name, if the name already exists, TOAD generates...