Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Full table scans

Full table scans

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 7 May 2003 09:29:38 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A4A011@lnewton.leeds.lfs.co.uk>


or even :

select * from users
where clue > 0;

No rows selected.

My all time favourite !

cheers,
Norm.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Wednesday, May 07, 2003 9:11 AM Posted To: server
Conversation: Full table scans
Subject: Re: Full table scans

Offensive sql - something following the idea of

create table t1
as select * from all_objects
where 'POPE'='CATHOLIC';

? Received on Wed May 07 2003 - 03:29:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US