Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to construct an SQL query?
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