Re: ** 8i to 10G conversion

On 04/05/2006 07:05:54 PM, Mark W. Farnham wrote:

> Now as for your applications, beware this quote from the November 1988
> pressing of the Database Administrator's Guide, Version 6.0, page 19-14:
>
> Under the heading: "Optimizing ORDER BY"
>
> "Though there may be several ways to word a SQL statement to achieve the
> ordering you desire, the only way to guarantee ordering is to use the ORDER
> BY clause at the end of a SQL statement.
> Results which appear ordered, but were not obtained using an ORDER BY
> clause, may not be returned in the same order in future releases....."

What the hell!? You are quoting Oracle manuals 6.0 from 1988? It must have been a beta version! In 1989 I was still working on 5.1.22 - the one with SY$ORACLE, VAX$BI, IOR, dictionary tables like "CAT", "TAB" and "IND" (all of which are still functional in 10.2) and init.ora parameters like "TABLES", "INDEXES" and alike. That was the time of SQL*Forms 2.3 and "failure/success labels", rpt/rpf and SQL*ReportWriter 1.0, more or less re-engineered from DEC's "Rally". How did you get hold of 6.0 manuals in 1988? You didn't have TPO, did you? I remember the year as that was the year I was authorized to teach Oracle5 DBA course in ex-YU by Oracle Austria. In 1990 I was authorized to teach the internals of Oracle6, which was an excellent addition to "Tuning VMS 5.0" course that I used to teach before.
After a course in in UK about a product called Cdict 4.1 (a granddaddy of Designer 2000) I came back and told to a friend who was an application developer that application development will soon be over as management will be able to feed the necessary information to the product and generate forms and reports they need. According to Oracle sales people from that time, the only people needed in an IT department will be managers and database administrators. Now, Oracle is attempting to eliminate even the DBA personnel, with the equal success displayed at elimination of application developers. Forgive me, in 1988 I was only 27 years old! I'm not shaking in my boots.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l