Re: dual table - 9iR2

Mark Townsend <markbtownsend_at_comcast.net> wrote in message news:<_TP1d.51464$D%.22777_at_attbi_s51>...
> Hans Forbrich wrote:
>
> >
> > Counter question - have you noticed whether the behaviour is duplicated in
> > any other client? Seems like the kind of thing for a RLS policy.
> >
> >
>
> It pretty much is a SQL*Plus funny - sqldba doesn't do it, neither do
> any of the programmatic interfaces.

I thought this was a SQL optimizer feature? Or it may be something in OCI8. It is definitely not a feature of SQL*Plus.

Metalink article 185438.1 mentions this happens from 8.0 onwards, which is when SQL*Plus started using OCI8.

• CJ