Re: How to construct an SQL query?

From: Paul Q <paulq_at_home.com>
Date: Mon, 14 Jun 1999 02:54:02 GMT
Message-ID: <e9_83.11920$Yr2.178813@news2.rdc1.on.home.com>

I hope your not making money for this Wassim. Is the data being being retrieved from one or more tables ? In either case as long as you can create the form properly with the joins between the two tables if this is the case.

Oracle will retrieve the appropriate data. By just enter_query and execute_query.

Wassim wrote in message <7k1dba$a1m$1_at_nnrp1.deja.com>...
>Hi,
>suppose that i have a form like this :
>name :
>date : from [ ] to [ ]
>
>[send] [cancel]
>
>i want to know how to construct the SQL query while i can't be done only
>dynamically because criteria of search are only known after submission
>of the form, search can be on 'name' only, or 'name'+'from_date' or the
>3 criteria..
>
>Have i to do it using UNION between 2 or 3 SELECT query?
>Thanks for help !!
>
>Wassim,
>e-mail: net2000_at_francemel.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jun 13 1999 - 21:54:02 CDT