Re: Sampling

Niall Litchfield wrote:

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3CE168C6.2D264750_at_exesolutions.com...
> > Bricklen Anderson wrote:
> >
> > > try it this way:
> > >
> > > select * from au_week_number sample (.05);
> <snip>
>
> > I believe this clause only applies to partitioned data.
>
> Nope works fine on ordinary tables. Note the banner shows this to be std
> edition and no partitioning.
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle8i Release 8.1.7.3.0 - Production
> PL/SQL Release 8.1.7.3.0 - Production
> CORE 8.1.7.2.1 Production
> TNS for 32-bit Windows: Version 8.1.7.3.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> SQL> select last_update from rm_atsinvtrans sample (0.005);
>
> LAST_UPDA
> ---------
> 07-JAN-00
> 06-MAR-00
> 06-APR-00
> 29-MAR-01
> 05-JUL-00
> 05-JUL-00
> 06-OCT-00
> 31-JAN-01
> 05-JAN-01
> 28-FEB-01
> 29-MAY-01
>
> LAST_UPDA
> ---------
> 29-MAY-01
> 02-JUL-01
> 02-JUL-01
> 02-JUL-01
> 02-JUL-01
> 28-AUG-01
> 28-AUG-01
> 01-OCT-01
> 28-JAN-02
> 26-NOV-01
> 03-DEC-01
>
> LAST_UPDA
> ---------
> 21-JAN-02
> 18-FEB-02
> 18-FEB-02
> 25-FEB-02
> 25-MAR-02
> 02-APR-02
> 02-APR-02
>
> 29 rows selected.
>
> SQL>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************

Interesting ... yesterday I tried the examples from: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/state21b.htm#2066411

on several different databases and had errors.

Today it works.

Daniel Morgan Received on Wed May 15 2002 - 17:34:07 CEST