Re: SQL plus problem

FABIO DA SILVA BORGES wrote:
>
> 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
> --------
> z
>
> Why didn't the tuple (26,z) appear in the first query???
> Wouldn't it be some configuration problem???
>
> Thank you for your attention.
>

But why do you have data like that in the first place? What meaning could such items have? The point is, you didn't post "real world" data nor a "real world" sql statement. Your hypothetical sql statement probably avoids the problem that your real sql has.

Have you tried entering a "show all" command to see if there are any settings for sql plus that are interfering with the output? Received on Fri Mar 31 2000 - 06:40:18 CST