Search the web
Sign In
New User? Sign Up
toad · Self Help List for TOAD Development Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 44540 - 44569 of 49316   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
44540
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@...
Send Email
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 <=...
Rob Zijlstra
rbzijlstra
Offline Send Email
Nov 3, 2008
12:27 pm
44542
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...
Dunbar, Norman
normandunbar
Offline Send Email
Nov 3, 2008
1:37 pm
44543
... 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...
Dunbar, Norman
normandunbar
Offline Send Email
Nov 3, 2008
1:38 pm
44544
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@...
Send Email
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...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 3, 2008
2:18 pm
44546
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...
John Dorlon
jdorlon3
Offline Send Email
Nov 3, 2008
2:23 pm
44547
We just got the Xpert version so we could use the sql optimizer...this is not part of the Xpert version?...
Wendy Penfold
wpenfold@...
Send Email
Nov 3, 2008
3:20 pm
44548
You should always be able to SEE a synch script, but you can't copy it out or apply it w/o the DB Admin module. From: toad@yahoogroups.com...
Jeff Smith
toaddev
Offline Send Email
Nov 3, 2008
3:22 pm
44549
and you cannot multi-select unless you have the DBA module - the base version lets you see one sync at a time ________________________________ From:...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 3, 2008
3:28 pm
44550
Hi, Does anyone know the Max. number of data that Toad can fetch? Thanks in advance, Lisa ...
Hu, Lisa
lisahu_812
Offline Send Email
Nov 3, 2008
4:06 pm
44551
depends on 1) how much ram is on your PC 2) how many columns in your table, and what type the columns are. From: toad@yahoogroups.com...
John Dorlon
jdorlon3
Offline Send Email
Nov 3, 2008
4:08 pm
44552
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...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 3, 2008
4:09 pm
44553
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,...
Jeff Smith
toaddev
Offline Send Email
Nov 3, 2008
4:19 pm
44554
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...
Hu, Lisa
lisahu_812
Offline Send Email
Nov 3, 2008
4:28 pm
44555
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...
Hu, Lisa
lisahu_812
Offline Send Email
Nov 3, 2008
4:29 pm
44556
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...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 3, 2008
4:31 pm
44557
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...
John Dorlon
jdorlon3
Offline Send Email
Nov 3, 2008
4:33 pm
44558
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...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 3, 2008
4:40 pm
44559
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@...
Send Email
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...
Hudson, James - DNR
jimhudson_50
Offline Send Email
Nov 3, 2008
7:06 pm
44561
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...
David A. Hicken
hickend
Offline Send Email
Nov 3, 2008
8:16 pm
44562
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 -...
John Dorlon
jdorlon3
Offline Send Email
Nov 3, 2008
9:11 pm
44563
Where do I set up an option NOT to uppercase keywords like SELECT, ORDER BY etc. Version 9.7.2.5 Thank you....
George.Meltser@...
georgemeltser
Offline Send Email
Nov 3, 2008
9:15 pm
44564
Formatting Options > Case > Keywords From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of George.Meltser@... Sent: Monday, November 03,...
Jeff Smith
toaddev
Offline Send Email
Nov 3, 2008
9:17 pm
44565
View-->Toad Options-->Editor-->Behavior tab Edit the PL/SQL language. On the highlighting tab, select the reserved word style. Change the capitalization effect...
Michael Staszewski II
mstaszew
Offline Send Email
Nov 3, 2008
9:17 pm
44566
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,...
Jeff Smith
toaddev
Offline Send Email
Nov 3, 2008
9:21 pm
44567
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@...
Send Email
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...
Andre Vergison
avergison
Offline Send Email
Nov 3, 2008
9:36 pm
44569
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...
Mahajan, Jayant
jmahajan@...
Send Email
Nov 3, 2008
10:00 pm
Messages 44540 - 44569 of 49316   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help