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

Home -> Community -> Usenet -> c.d.o.misc -> How to construct an SQL query?

How to construct an SQL query?

From: Wassim <net2000_at_francemel.com>
Date: Sun, 13 Jun 1999 23:03:09 GMT
Message-ID: <7k1dba$a1m$1@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 - 18:03:09 CDT

Original text of this message

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