Your SQL Tool Part II
As a follow-up to my previous post about the different SQL development tools, here is the result of the quick poll I had on this site.
I asked the question: What SQL development tool do you use most? There were a total of 150 answers, broken down like this: Continue reading…
3 Comments | Filed in Oracle, Technology | Tags: plsql-developer, sql, sql-developer, sql-navigator, sqlplus, toad, toolSQL problem
I have noticed this interesting thread on the Oracle-l mailing list about a “seemingly simple SQL requirement”. The question was about how to write a query that returned NO rows from a table t – with an id column – whenever a given list of id’s contained at least one id that did not exist in the table t. To illustrate: Continue reading…
11 Comments | Filed in Oracle | Tags: sqlHit every minute
Today, and for the first time (and hopefully the last), I had to deny an IP address access to my site. Starting at around 9:00 AM, I had the following IP hitting the same post on my blog at a rate of once per minute: Continue reading…
7 Comments | Filed in Personal | Tags: blog, statisticsHigher-Speed Internet
Competition is good. As soon as Verizon finished installing its own fiber optic network in my neighborhood, and promised higher Internet speed, I got a letter from Comcast (my current ISP) informing me that they had just bumped up their standard downstream speed to 6000 Kbps. Sweet. I immediately power cycled my cable modem and went to this site to test my Internet speed. Here is the result: Continue reading…
3 Comments | Filed in Personal, Technology | Tags: broadband, internetUnderscores make a difference
I was setting up my environment to test out the examples in the book “Expert Oracle Database Architecture“. I started to set up runstats, a tool that measures the elapsed time, system statistics and latching. To use runstats, I (scott/tiger) needed access to some v$ tables (a.k.a. magic dynamic performance tables). On page xxxii of the book, it says: Continue reading…
7 Comments | Filed in Books, Oracle, Tips | Tags: book
