From oracle-l-bounce@freelists.org Fri Oct 7 15:10:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j97KAUTt017414 for ; Fri, 7 Oct 2005 15:10:40 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j97KAEvX017377 for ; Fri, 7 Oct 2005 15:10:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90F041F8882; Fri, 7 Oct 2005 15:09:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04679-06; Fri, 7 Oct 2005 15:09:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16A041F8869; Fri, 7 Oct 2005 15:09:26 -0500 (EST) Message-ID: From: Kevin Lange To: oracle-l Subject: Random Select of X % of total records Date: Fri, 7 Oct 2005 15:07:25 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CB7A.BC55DEC0" X-archive-position: 26582 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: klange@ppoone.com Precedence: normal Reply-To: klange@ppoone.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CB7A.BC55DEC0 Content-Type: text/plain; charset="iso-8859-1" Evening all; One of our developers is asking if there is a simple SQL way to generate a random select of the total records in a table. i.e. They want to see 10% of the records in the CLAIMS table. Database in question is 9i (9.2.0.6) SQL has to be simple because its going to be used by Cognos which does not allow anonymous sql blocks. I was hoping that some of the new analytical functions would work for this but I have not used them yet. Any help out there ?? ------_=_NextPart_001_01C5CB7A.BC55DEC0 Content-Type: text/html; charset="iso-8859-1"

Evening all;

One of our developers is asking if there is a simple SQL way to generate a random select of the total records in a table. i.e. They want to see 10% of the records in the CLAIMS table.

Database in question is 9i (9.2.0.6)

SQL has to be simple because its going to be used by Cognos which does not allow anonymous sql blocks.

I was hoping that some of the new analytical functions would work for this but I have not used them yet.

Any help out there ??

------_=_NextPart_001_01C5CB7A.BC55DEC0-- -- http://www.freelists.org/webpage/oracle-l