Re: Why I too don't like the OCP

"Vladimir M. Zakharychev" wrote:

> Actually, DBA doesn't have to know what rownum is and how it is implemented -
> DBAs don't deal with it, since it's not stored anywhere in the database and shouldn't
> be either backed up or restored. :)
>
> --
> Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
> All opinions are mine and do not necessarily go in line with those of my employer.
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3cca6e63$0$232$cc9e4d1f_at_news.dial.pipex.com...
> > "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > news:3CCA2F23.C5C53DC2_at_exesolutions.com...
> > > Nuno Souto wrote:
> > >
> > > > In article <3CC9B286.5FB5_at_yahoo.com>, you said (and I quote):
> > > > >
> > > > > True story from lazydba.com
> > > > >
> > > > > "What does rownum mean?
> > > > > Signed xxx
> > > > > OCP 7,8,8i"
> > > > >
> > > >
> > > > LOL!
> > > >
> > > > --
> > > > Cheers
> > > > Nuno Souto
> > > > nsouto_at_optushome.com.au.nospam
> > >
> > > Sorry to say it but I can name a large number of DBAs. Some that have
> > > had that title for 10-20 years that couldn't answer that question.
> >
> > My thought for the day.
> >
> > So what is rownum and how is it implemented in the oracle database.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> >
> >

Unless of course they are asked to go to code reviews or to deal with queries that don't work because they are presumed to be the experts.

I met a DBA asked to solve a problem with a query that looked like this:

SELECT *
FROM mytable
WHERE rownum BETWEEN 10 AND 20;

Guess what happened?

Daniel Morgan Received on Mon Apr 29 2002 - 11:21:09 CDT