Re: Query Builder Syntax Help Needed
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 04 Feb 2005 17:21:17 +0100
Message-ID: <cu07ar$499$1_at_news3.zwoll1.ov.home.nl>
>
> 1. SQL*Plus.
>
> select *
> from all_objects
> where object_name like '%&keyword%'
> /
>
> after run this, you get prompt for search objects with name containing
> :keyword.
>
> 2. Query Builder.
>
> select *
> from all_objects
> where object_name like :keyword
> /
>
> Save this sql statetment and load file into QB.
> You should get a keyword automaticaly created in QB and there is a
> field you can enter '%' things.
>
>
>
Add an UPPER():
where object_name like upper('%&keyword%')
Date: Fri, 04 Feb 2005 17:21:17 +0100
Message-ID: <cu07ar$499$1_at_news3.zwoll1.ov.home.nl>
Noel wrote:
> Użytkownik SteveOz napisał:
>
>> Hi from a newbie, >> >> I hope I'm in the right place. I build queries in Query Builder and, in >> general, have no resources to compare my syntax and would love to find a >> resource (maybe with actual examples). >> >> Specifically, I am trying to find a way to search a field (char (500) or >> something) for a string that arrives by prompt. I've defined a query >> parameter that accepts a keyword for searching but can't get the syntax >> straight. This is where I am: >> >> db.application.project_title LIKE :keyword >> >> I don't know what function to use or how to incorporate the wildcard >> '%' on >> either end. Can you help? >> >> :) Steve >> >>
>
> 1. SQL*Plus.
>
> select *
> from all_objects
> where object_name like '%&keyword%'
> /
>
> after run this, you get prompt for search objects with name containing
> :keyword.
>
> 2. Query Builder.
>
> select *
> from all_objects
> where object_name like :keyword
> /
>
> Save this sql statetment and load file into QB.
> You should get a keyword automaticaly created in QB and there is a
> field you can enter '%' things.
>
>
>
Add an UPPER():
where object_name like upper('%&keyword%')
-- Regards, Frank van BortelReceived on Fri Feb 04 2005 - 17:21:17 CET