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: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 21 Apr 2006 14:49:20 -0800
Message-ID: <44495360$1@news.victoria.tc.ca>


Cris Carampa (cris119_at_operamail.com) 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=20
: rows where this field is between 3 and 5" or "fetch all the rows where=20
: this field is 3 or 5 or 7".

: I know that with the "&" symbol you can inject straight SQL into the=20
: query, but our users refuse to use it because they have to remember the=20
: names of the database columns.

: I tried to write things like "between 3 and 5" and "in (3,5,7)" in=20
: numeric fields but the Forms engine doesn't seem to like it.

	#between 3 and 5
	^

I think the term you want to search is "query by example". Include the word Oracle somewhere in your search. Received on Fri Apr 21 2006 - 17:49:20 CDT

Original text of this message

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