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

Home -> Community -> Usenet -> c.d.o.misc -> SQL - Select 1 row only from a table.

SQL - Select 1 row only from a table.

From: Craig Burtenshaw <crb_at_amsa.gov.au>
Date: Thu, 1 Apr 2004 12:58:21 +1000
Message-ID: <406b8559$0$93305$c30e37c6@lon-reader.news.telstra.net> 





Hi,



Is there away of selecting records from a table using 'select (1) from table
where column = x' and


as soon as there one record (out of a possible 100), stop and give a
response?



Oracle 8.1.7.4


Solaris 2.7



Thank you


Craig.
Received on Wed Mar 31 2004 - 20:58:21 CST












Original text of this message













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