Greetings from across the pond Roger so when will *they* ever learn the Kings English! "My hovercraft is full of eels" Martin GMT+5 Programming/Database...
Martin Gainty
mgainty@...
Nov 1, 2008 4:37 pm
44541
Whatever I change in the formatting settings, the indenting of new lines in a piece of code remains 1. Example: IF ry.abzdat IS NOT NULL AND ry.abzdat <=...
I'm still behind on my versions and I cannot do anything about it, sorry! This may be fixed in later releases, if so, tell me to go away! In the SB, I have the...
... Ok, not quite true I have discovered. If I'm looking on the data tab for a table, it scrolleth not. If I'm looking at a list of tables, for example, it...
Hi, I'm comparing schemas in version 9.7.0.51 In the results screen I would like to be able to select just a few items and get the synch script but on both...
Wendy Penfold
wpenfold@...
Nov 3, 2008 2:16 pm
44545
Do you own the DBA Module? If not, then you don't get that feature ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On...
I don't know Norm, I can't reproduce that in either 9.5 or 9.7. So I guessing it is options related, or maybe I'm just missing something. I tried with both...
and you cannot multi-select unless you have the DBA module - the base version lets you see one sync at a time ________________________________ From:...
limited only by your PC's available memory - but I've done millions of rows without issue If instead you mean to export to say an excel spreadsheet or data...
Where are you running into a problem, or are you just curious? From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert Scalzo Sent: Monday,...
Ram is 580M, table has 30 columns and datatype is VARCHAR2(50 BYTE). Thanks, Lisa ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of John...
I was just wondering because it stopped at a 1,350,999 but it said there were more rows existing. It finally did start counting again after about 15 minutes...
You can set some toad options to control some aspects of this - browse the options for example, if you fetch to grid - it must fit in memory. If you say save...
Sorry, I didn't mean to imply that I'd be able to tell you how many rows you'll be able to retrieve. It's impossible for me to tell you that. I just meant...
that's why I replied look at the save as - because why squeeze 2 million rows into memory/grid - save it to a file if you simply need access to it - and the...
Good Morning; With the way you have your statement coded, I suspect it would also fail to do what you want in SQLPLUS. Try it in SQLPlus without the carriage...
Simoneau, Roger
rsimonea@...
Nov 3, 2008 5:20 pm
44560
I was doing some comparisons of some views today. On 9.1 (should get to at least 9.6 soon, thankfully). Since you can't work directly on views, I took the data...
The code in the file is as written in the first example. When I retrieve said code, it automatically reformats to the second example. It will run in QSR or...
Thanks for the idea, Jim. I can't get to this one right now, but I'll keep it in my inbox until I can. Sounds like you are aware of it, but just in case -...
Formatting Options > Case > Keywords From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of George.Meltser@... Sent: Monday, November 03,...
View-->Toad Options-->Editor-->Behavior tab Edit the PL/SQL language. On the highlighting tab, select the reserved word style. Change the capitalization effect...
As you type it vs as your format it :) From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Michael Staszewski II Sent: Monday, November 03,...
Sorry, my misunderstanding of what you were asking. It's time for my week off - which is next week. RAS ... From: toad@yahoogroups.com...
Simoneau, Roger
rsimonea@...
Nov 3, 2008 9:31 pm
44568
This is a bug: a statement which cannot be formatted (for whatever reason) can stick to the previous statement. This has been fixed but I’ll have to ask the...
Hello I am current on maintenance. I am planning to upgrade from TOAD 9.1.0.62 to current version 9.7.2.5 What is the best thing to do? Upgrade to 9.7.2.5 or...