... Use a Min() or Max() on the User column and group by your first three fields: select year, code, dept, max(user) from table group by year, code, dept; Doug...
Angelo: You have different “User” name in your DB. So when you use this SQL: Select * from TABLE_NAME; It would not get the records that you want. I think...
ZHENG Yuan (SCC-IT)
yuan.zheng@...
Apr 1, 2009 10:08 am
46798
Then what is the output you want to have? In your example Jane and Amy are left out, so you want a random name or something like that? Strange request. But it...
First a question: Which Toad version. Could be important. I've checked it with Toad I use now (9.8.0.19 yes, a beta). It gives 500 records, but the checkbox...
Morning Angelo, ... When you select distinct the ALL the columns after the distinct keyword have to be unique. You cannot, for example, select distinct (year,...
The query remains open I believe until all the data has been fetched. Even with the one fetch limit, if they were to scroll down the grid, Toad would continue...
Limit Grid Fetch - that's a new one for me! What it doesn't explicitly say though is that the query/connection is dropped after the initial fetch...is that...
What exactly do you mean by "continues"? The cursor stays open, this is by design. It should not continue to fetch past the first 500 records unless you...
The cursor is not closed after the fetch. If we were to close the cursor, the data would disappear from the grids. If you want to see data after closing the...
That's what I was thinking. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of John Dorlon Sent: Wednesday, April 01, 2009 8:48 AM To:...
This looks like a poor student who is trying to get his homework done. Especially since he does not have the courtesy to send it to TOADSQL. Erwin Rollauer,...
You can off course start another Toad. If you has the options correct for multiple Toads.Stability? Let's say I don't like the odds. In the past it was...
Afternoon Erwin, ... Well, let's not be too hard, plenty of posts here are off topic to certain degrees. And if he is trying to get help with his homework, he ...
I have no problem with off topic stuff as it is not SQL since we don't have a TOAD_OFFTOPIC list. Maybe we should. Possibly also a TOAD_TALKLIKEPIRATE list....
There shouldn't be a TOAD stability issue. Just make sure you don't change column orders or options or things like that. Though possibly the options are now...
dont forget Gordon,Barack,Angela and Nicholas! Martin ______________________________________________ Disclaimer and confidentiality note This message is...
Martin Gainty
mgainty@...
Apr 1, 2009 2:14 pm
46812
Martin, ... Who? ;-) Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by...
Toad-Newbie here ! I'm sure that there must be a way to do this, but I cannot find it and am not sure what to search for either. I have an Oracle database with...
... Actually, there is a random function but it's very limited. You'd have to write a fairly complex query (compared to just using min/max) to get it to work...
Simoneau, Roger
rsimonea@...
Apr 1, 2009 3:49 pm
46815
Good Morning; This morning I had the latest version of Toad installed. It appears I wasn't prepared for the capabilities and am rather overwhelmed by the...
Simoneau, Roger
rsimonea@...
Apr 1, 2009 4:14 pm
46816
Hey Roger, The answers to your questions are very in-depth. From your comments, I assume you've read the manual. I'd also recommend: ...
First thing I thought of is the Data Subset wizard (options-->Database-->Export) but not don't think you can feed it a group of tables. It looks like it only ...
Ahh... the Help files listed the manual but I thought that was a misprint as I hadn't been provided with it. I guess for now I'll just have to work through the...
Simoneau, Roger
rsimonea@...
Apr 1, 2009 4:35 pm
46819
I'm not sure how you define "Most Popular" but check the ALL_TABLES view to list your tables. Then you can create a PL/SQL script to cycle through those rows ...
#2 - look at the new toad beta (9.8) - the ER Diagrammer was totally redone and so much better now #1 - see my blog on writing dynamic sql sscripts - so the...
When doing a blog like the one below with screen shots it might be a good idea to copy the script text and show it as text below the screen shot. The image,...
... Hey Erwin, just get version 143.5.9.7 installed. It takes care of that sort of thing. You might have a bit to wait for the manual though. I just...
Simoneau, Roger
rsimonea@...
Apr 1, 2009 5:07 pm
46823
Hi, I've recently set up Toad on my new laptop. It's a Mac so I'm running in a VM. Whenever I start Toad I get an AV. Here are the details ... EurekaLog...
You can Google search this technique from numerous places - this is an old SQL coding trick that Toad with it's sql plus compat supports. The pattern is...
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.
