Re: SQL plus problem

OK, the query looks like this:

select a,b from c

and yields the following

  a b
------ -------

1	a
2	b
3	c
4	d
...
15	o

But the table "c" has more than 15 rows. The query:

select b from c where a=26

yields

   b

Why didn't the tuple (26,z) appear in the first query??? Wouldn't it be some configuration problem???

Thank you for your attention.

On Thu, 30 Mar 2000, RC wrote:

> Well I can't answer without seeing an example of the query and I have never
> seen this problem before. Do you have something in the where clause such
> as rownum < 16? More information is needed to answer you question.
>
> HTH
>
> RC
> FABIO DA SILVA BORGES wrote:
> >
> >
> > Helo,
> >
> > I have a problem using SQLPlus 8.0.3.
> > All my queries return at most 15 rows, even when they should
> > return more than 15 rows.
> > Why does that happen and what should I do to have my queries
> > returning the correct number of rows??
> >
> > Thanks,
> >
> > Fabio Borges
> > Computer Science student at Campinas University - UNICAMP, Brazil
> >
> >
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>
>
Received on Thu Mar 30 2000 - 18:06:18 CST