Correction to script in Oracle magazine Sum 92

From: bdfh <kml_at_cellar.org>
Date: 20 Jul 92 15:31:38 GMT
Message-ID: <FNV8NB1w164w_at_cellar.org>


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_at_cellar.org (bdfh)
The Cellar BBS - (215) 654-9184 Received on Mon Jul 20 1992 - 17:31:38 CEST

Original text of this message