18 September 2006

Count and Filters...

I'm still testing and working with SQL Developer 1.1, so have neglected this blog for a while. I am sure you're out and about doing the last of summer things, assuming you live north of the equator, or looking forward to spring, if you're down south! Either way, I doubt you'll have missed this too much.

I'm working through my morning tasks and today, that includes reviewing my bugs that have been closed. Here's one I've just looked at.

Users on the forum were frustrated that when you apply a filter to your data, in SQL Developer 1.0 and then tried to Count the records, the response was a count of all the records. So apart from writing the SQL, the request was to know how many records are returned, with a filter applied. Here you go, a simple context menu option:

Posted by Sue at 11:42 am
Labels:

4 comments:

Anonymous said...

Hi Sue,

Is SQL Developer a free tool?

Mustafa

Mon Sept 18, 01:31:00 pm GMT
Michael A. Rife said...

Yes it is free. Here is a link:
http://www.oracle.com/technology/products/database/sql_developer/index.html

Mon Sept 18, 02:35:00 pm GMT
Anonymous said...

Sue,

You said: "I doubt you'll have missed this too much."

"Too much" is a relative term, but rest assured that though we may not add to many comments/questions, we are (I guess) quite a bunch checking in on your blog to see where you're going..

So keep it going.
BTW, when will we see some SQL Developer stuff on thedailywtf.com ? ;-)

Jens from Norway

Thu Oct 05, 09:34:00 am GMT
Sue said...

Thanks for the nudge Jens, I will get back on track.

Sue

Thu Oct 05, 10:13:00 am GMT

Post a Comment

Subscribe to: Post Comments (Atom)