home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!pitt.edu!gvls1!tredysvr!cellar!kml
- From: kml@cellar.org (bdfh)
- Newsgroups: comp.databases.oracle
- Subject: Correction to script in Oracle magazine Sum 92
- Message-ID: <FNV8NB1w164w@cellar.org>
- Date: 20 Jul 92 15:31:38 GMT
- Sender: bbs@cellar.org (The Cellar BBS)
- Organization: The Cellar BBS and public access system
- Lines: 14
-
- There is a minor typo in the "Lies, Damned Lies, and Hit Ratios" article
- that appears in the Summer 92 edition of Oracle Magazine. The code in the
- bottom-left corner of page 45 contains an Update command. In the Where
- clause of the subquery of that command, the same mistake is made twice.
- The lines "where h2.check_date=hitratios.check_date and h2.check_hour =
- hitratios.check_hour" should be modified, replacing "hitratios" with
- "hit_ratios". This is a minor point, but typing it as shown in the
- article will result in a table-or-view-does-not-exist error.
-
- -Kevin.
-
- ------
- kml@cellar.org (bdfh)
- The Cellar BBS - (215) 654-9184
-