|
Friends - Once upon a time, a very long time ago, I
had a large black notebook. I found
it in my cube when I moved into it in 1985. I think it was from v4 days as it was
old and dog-eared and we were currently on v5.0.14 or thereabouts. Anyway, this notebook was a tutorial
that Oracle put out on all its wonderful features in SQL*Plus, based on
SCOTT/TIGER. There were queries and
joins and correlated subqueries and uncorrelated subqueries.
There was GROUP BYs and CONNECTs. There
were UNIONs and INTERSECTs
and MINUSs.
There were DECODEs and NVLs
and lots of different DATE functions.
There were tricks to do with MOD, and ABS and SIGN, and the 101 ways to
spend your vacation in the DUAL table.
Overall, it was a grand frolic of SQL, and, geek that I am, I really
enjoyed it. Of course, I left that notebook in the cube when I left the
company having gone through the book to teach myself SQL after long years of
QUEL. The years have gone by, and
now I'm in a new company with a lovely boss who's an old geek too,
but on the IBM side. This is his
first exposure to Oracle and I wanted to get him a grand frolic through the
non-ANSI standard extensions of Oracle, and would have *thought* that a book similar to my old
black notebook but even bigger and better would still be in existence
somewhere. But try as I may, I can't find anything like it. In fact, even getting a vanilla 5 page "this
is scott/tiger" set of introductory exercises
is not as easy as one might think. I'm
going to snag one off of google. But, in the meantime, does anyone know
of an online version of "this-is-all-the-cool-sh*t-you-can-do-in-Oracle-whether-or-not-its-ANSI-standard-(ANSI-is-for-wimps-anyway)"
floating around? So as not to pester the List, if you could email me directly,
that would sure be swell. And, as always, your thoughts are
appreciated. Best wishes! Bambi. |
Title: RE: HOW TO KNOW INDEX NOT IN USE?
