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 -> Re: sql question

Re: sql question

From: Alan <alan_at_erols.com>
Date: Mon, 27 Sep 2004 13:24:06 -0400
Message-ID: <2rr0loF1bkavhU1@uni-berlin.de>

"Oxnard" <shankeyp_at_no-spam.comcast.net> wrote in message news:hYqdnTbMX6C52sXcRVn-jQ_at_comcast.com...
> I'm trying to generate an SQL that will return the lowest usable value
which
> is higher than zero. Here is the situatuion:
>
> DB versio 9.2.0.5.
>
> create table mynum(
> num number constraint mynum_pk primary key,
> );
>
> insert into mynum(num) values (1);
> insert into mynum(num) values (2);
> insert into mynum(num) values (4);
> insert into mynum(num) values (5);
> insert into mynum(num) values (6);
>
> In this case I am looking for a 3 to be returned. I know I can do it with
> PL/SQL but I would like to use a single SQL statement.
>

Why? Received on Mon Sep 27 2004 - 12:24:06 CDT

Original text of this message

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