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: Oracle Forms and special query operators

Re: Oracle Forms and special query operators

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Apr 2006 09:17:28 -0700
Message-ID: <1145549843.879913@yasure.drizzle.com>


Cris Carampa wrote:
> Hello,
>
> I do know that in Oracle Forms it's possible to use special symbols like
> ">" and "<" in query mode. For example, entering "<3" in a numeric field
> means "fetch all the rows where this field is less than 3".
>
> I would like to know if there's a way to ask things like "fetch all the
> rows where this field is between 3 and 5" or "fetch all the rows where
> this field is 3 or 5 or 7".
>
> I know that with the "&" symbol you can inject straight SQL into the
> query, but our users refuse to use it because they have to remember the
> names of the database columns.
>
> I tried to write things like "between 3 and 5" and "in (3,5,7)" in
> numeric fields but the Forms engine doesn't seem to like it.
>
> Has someone out there already faced the same problem?
>
> Thank you. Kind regards,

Type in an ampersand "&" and execute the query. You can type in an entire WHERE clause with AND and OR if you wish.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Apr 20 2006 - 11:17:28 CDT

Original text of this message

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