Re: what does sample means?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 18 Jun 2001 04:53:51 -0700
Message-ID: <9gkq4f02f1q@drn.newsguy.com>

In article <9gk22h$8bi$1_at_imsinews.kornet.net>, "Á¤¿µ¼®" says...
>
>select * from tableA sample (20)
>=============================
>
>In this sql, what does sample(20) and what sample means?
>
>Thanks in advance,
>
>

see
http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4l2.htm#13327 ...

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Jun 18 2001 - 06:53:51 CDT