Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Query Builder Syntax Help Needed

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@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 Bortel
Received on Fri Feb 04 2005 - 10:21:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US