On Apr 13, 5:08 pm, Gints Plivna <gints.pli...@[EMAIL PROTECTED]
> wrote:
> On 4 Apr., 12:51, banaslee <banas...@[EMAIL PROTECTED]
> wrote:
>
>
>
> > Hi there.
>
> > I'm new to oracle and I'd want to build a form search.
> > I'm currently using dynamic sql to append all the where clauses that
> > has no null values on the corresponding form text boxes but I'm
> > searching for a more elegant and static solution.
>
> > In text I can use WHERE nvl(a.foo, ' ') =3D b.foo || '%' so that if
> > b.foo is null it returns all the a.foo rows and I can still use an
> > index if I create it like CREATE INDEX foo_idx ON a(nvl(foo, ' ')).
> > But what about number values? Is there any better solution for them?
>
> > I hope I had been enough specific on my question.
>
> > Thanks in advance for your help,
> > F=E1bio Oliveira
>
> For different possibilities look
herehttp://asktom.oracle.com/pls/asktom/f=
?p=3D100:11:0::::P11_QUESTION_ID:1...
>
> Gints Plivnahttp://www.gplivna.eu
Thanks a lot! I was looking for an explanation like that since the
beginning. "Cursor" is not the best title for that article though.
|
